Export multiple datasets to one Excel file

J

Jay

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.
 
Top