Export to excel. (1 Viewer)

W

WideBoyPJ

Guest
I have a query which has produced over 20000 lines (but less than 30k) so it should export to excel, I can cut and paste.

Is there anything that could force it out.

The way I am currently doing this is using a macro to open the query as only 1 item from the list is needed and the person will specify this before export. Then I am using an outputto command to put the sheet in to excel.

Thanks for any help

Pj
 

WayneRyan

AWF VIP
Local time
Today, 11:34
Joined
Nov 19, 2002
Messages
7,122
Pj,

Put something like the following in the OnClick of a command
button:

Code:
  DoCmd.OutputTo acOutputQuery, "qryYourQuery", acFormatXLS, "C:\SomeFile.xls", True

Wayne
 
W

WideBoyPJ

Guest
Thank you for the advice.

In the end another query sorted the problem.

However if I have this again at least I will know what to do.

Cheers
 

Users who are viewing this thread

Top Bottom