Export Query to Excel using DOcmd.OutputTO

[AHFMR]

When I use the DoCMD.OutputTo to save a query to an Excel file the statement works fine the first time but it deletes the SQL statement after it is done saving the excel file.


DoCmd.OutputTo acOutputQuery, "Query Name", acFormatXLS, strXLfile, True

Any assistance is appreciated.

AHF

 

[jebry]

Hi!

Use DoCmd.TransferSpreadsheet instead.

hth

Jeff Bridgham
Purdue University
Graduate School
Data Analyst