Exporting Report to multiple Excel sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I have a report that is about 15 pages. Is there a way to export the report
to Excel, but have each page exported to a different sheet in one workbook?
For example, Page 1 of the report is exported to Sheet 1 in the workbook,
Page 2 to Sheet 2, etc..
Any help or direction is greatly appreciated. Thanks,

Matt.
 
Not really. In any case, you will probably find reports do not export well
to Excel. They will loose all formatting and the positioning will likely be
incorrect. If it is absolutely necessary to present your data in excel,
there are a couple of options. The most simple would be to export the data
directly to Excel or, if you need it formatted is certain ways, then
Automation is your best possible solution.
 
Have you tried importing in Excel from Access, rather than exporting from
Access to Excel?
 
Back
Top