Export multiple datasets to one Excel file

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

Guest

I have five Access files.
Let's say query1, query2, , query5 from those five Access databases.
I want to export results of quey1,..query5 to one Excel file named "Daily
Report"
How can I?

Thank you for your help
 
Check out TransferSpreadsheet -- it'll let you do that, and will put each
uniquely named query onto its own spreadsheet within the same file.
 
Back
Top