Export Multiple Query results from Access 2003 to one Excel Sprdsh

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

Guest

I have 15 queries set up to run in a Macro and want to export the results of
all of those queries in to one Excel Spreadsheet/Workbook. Can this be done
without using VB? If so, how?

Thank you.
 
I have 15 queries set up to run in a Macro and want to export the results of
all of those queries in to one Excel Spreadsheet/Workbook. Can this be done
without using VB? If so, how?

Thank you.
Click to expand...

Without VB? Sure.
You can manually select the query then click File + Export each time,
but wouldn't a few lines of code using the TransferSpreadsheet method
be easier and less prone to error?
 
It would be 100 times easier for sure. Automation is definitely preferred.
However, I know nothing about writing code in VB. Would you happen to know
what code would be necessary to make this happen?

Thank you.
 
You must log in or register to reply here.

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

Access 2003 db's & problems exporting query to Excel 1
Exporting Query from Access 2007 to Excel 2007 4
Exporting Access query to Excel file with passwords 6
Export query to Excel fails 6
Macro - Access 8
Open Access query in Excel with 'save formatted' 2
Export to Excel 3
Ranking Results of a Query 9

Back
Top