Exporting Report to multiple Excel sheets

M

Matt

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.
 
K

Klatuu

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.
 
J

JC

Have you tried importing in Excel from Access, rather than exporting from
Access to Excel?
 

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

Section and Page numbering 0
Images are pixelated when saving to PDF 0
Weekly Report 2
Mail Merge Directory Conditional Page Break 0
Shift Collate sheet 1-20 when printing entire workbook? 0
Page numbering with Merged Document and IF statements 1
Converting excel to PDF, single page converts to multiple HELP! 1
Report Group Footer DLookUp 0

Top