Export Report to Excel

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
 
A

Adam P

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