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"
 
You must log in or register to reply here.

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 Data to One Excel Workbook to Several Worksheets 2
Exporting pivot tables to excel 1
Macro to export query to Excel 2
Access Report 1
Export to separate sheets 2
Export Access Report to Excel 4
Export Report to Excel 2
How do I export a report to Excel in Access 2007 1

Back
Top