Export Report to Excel

  • Thread starter Thread starter AdisRod
  • Start date Start date
A

AdisRod

Hi,

I have 20 pages access report. I want export each page to
different excel sheet in the same workbook?

Thank you in advance,


Adis
 
This may not be what you're looking for, but this works
for queries.

The following will append
multiple queries to one sheet in excel:

DoCmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel9, "File name", "File path\File
name.xls"

Or, you can use this code to make multiple sheets:

DoCmd.OutputTo acOutputQuery, "File name",
acFormatXLS, "File path\File name.xls"
 
Back
Top