Output Access Query to Excel Spreadsheeet

[Guest]

I am exporting six queries with a DoCmd "Output To" to an excel spreadsheet.
The problem is that it creates six different spreadsheets. Is there a way to
"output" each of these queries to a different tab (i.e. work orders, purchase
orders, cost adjustments) on one spreadsheet.

 

[Ken Snell \(MVP\)]

Use the same file name for the EXCEL file in all of the exports. Just be
sure that each query has a different name.

 

[Guest]

Ken,

I tried this method and the second command overwrote the first spreadsheet.
Here is an example of the code I used:

DoCmd.OutputTo acOutputQuery, "100 Blanket Contract in Closed Centers Qry",
acFormatXLS, "C:\Documents and Settings\test.xls"
DoCmd.OutputTo acOutputQuery, "110 Change Order in Closed Centers Qry",
acFormatXLS, "C:\Documents and Settings\test.xls"

I would like the output of these two queries to be in one workbook with two
worksheets named such as Blanket Contract and Change Order.

Hope you can help.

Frankjl

 

[Ken Snell \(MVP\)]

My error; I misread your post. Use DoCmd.TransferSpreadsheet instead of
DoCmd.OutputTo.

 

[Guest]

Great!!

Thanks for your help!!

Frankjl

My error; I misread your post. Use DoCmd.TransferSpreadsheet instead of
DoCmd.OutputTo.