Export

[Elamranii]

Hi,
I have a macro to export 5 queries to an excel sheet. When I ran the Macro it exports the first 4 queries but get stuck on the last one. I ran the query by itself and copy it but can't paste it to an excel sheet. I am not getting an error message it just takes forever.
Does anybody knows a solution to this problem?
Thanks in advance
Ismail

 

[PHV]

How many rows does this query return ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Elamranii]

16297.

 

[PHV]

How you tried to pull the data from excel (menu Data -> External data -> ...) instead of push with access ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Elamranii]

I am sorry I am not sure of what you mean by :
How you tried to pull the data from excel (menu Data -> External data -> ...) instead of push with access ?
I have a macro to export to excel. Here is an example of the output file:
K:\Stat5Data\Stat5 Access Rpts\Hospital Summary.xls

 

[PHV]

Sorry for the typo, my question was:
Have you tried to pull the data from excel ?

 

[Elamranii]

You mean from access. I tried to copy the data straight from the query and paste to excel but it does not paste.