Export to separate sheets

[acss]

How does one export several query's to excell so each query has its own sheet
within the same workbook?

 

[Ken Snell]

Using TransferSpreadsheet method, use each query's name as the "exported
table/query", and use the same path/filename to the EXCEL file for each
export.

See http://www.accessmvp.com/KDSnell/EXCEL_Export.htm for various code
examples.

 

[Klatuu]

Look in Accesss Help for TransferSpreadsheet. Whether you use the Action
for a macro or the Method for the Docmd object using VBA, there is an
argument that you can use to specify the sheetname.