Export multiple datasets to one Excel file

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
 
K

Ken Snell \(MVP\)

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

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 several datasets to one Excel file 1
New query which is sum of 5 queries 1
Export to Excel 1
Export to Zip 1
calling subreports in subreports 6
Export Access Report to Excel 4
Export from Access 2007 Report to excel 3
Export Many Unrelated Access (2000) Data Tables to Excel 6

Top