Exporting several datasets to one Excel file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 12 Jul 2007 00:58 GMT

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

Reply to this Message

scubadiver - 12 Jul 2007 07:48 GMT

Use the following code in an "on click" event:

DoCmd.TransferSpreadsheet acExport, _
acSpreadsheetTypeExcel9, "QUERYNAME", _
"EXPORT LOCATION", , "SHEETNAME"

You can use this code multiple times in the same event. Change the query
name and the sheet name. The export location stays the same and it the
filepath shouldn't be too long (I've been told the maximum is 64 characters)

> I have five Access files.
> Let's say query1, query2, , query5 from those five Access databases.
[quoted text clipped - 3 lines]
>
> Thank you for your help

Reply to this Message