How can I export multiple queries to the same excel file?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I export multiple queries to the same excel file? Is it possible to
do it with a Macro and the OutputTo action? or do I need to do it using VB
modules.
Thanks
 
Use a macro to run the TransferSpreadsheet action. So long as each query has
a different name, you can use the same EXCEL filename and each query will be
written to its own worksheet within that file.

You also can do this via VBA code using DoCmd.TransferSpreadsheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exported Excel File is Incomplete 14
Output to Excel 2
Align Data Before Exporting to Excel 1
Export to Excel 1
export to excel - encoding problem 0
run saved IMPORT specification from a button in a form 1
Report Export to Text File 1
exporting subform data 1

Back
Top