Exporting Multipe query to a single workbook

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

Guest

is it possible to export mutiple queries to a single workbook with a tab for
each export using access macro outputto
 
Although Doug's article is very useful, it might be overkill for your
situation. Try using the TransferSpreadsheet Method first. Help explains
what the arguments do. You may need to create a query to select the data
you want to export especially if you want to do any formatting.
 

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

Exporting Query from Access 2007 to Excel 2007 4
Export to a specific worksheet in workbook 7
export query to delimited csv file 3
Exporting to Excel 4
Access "OutputTo" Command HTML Template 0
Exporting query to table in external database 4
Export table 1
Multiple tables output to multiple sheets in single excel workbook 7

Back
Top