By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 938 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

Exporting a access report to Excel spreadsheet

P: n/a
I used to export my reports as snapshot but now I have to export them
to Excel
When I export my report to a Excel Spreadsheet the report header and
footer are not included
Only the data gets exported.
How do I format a Access report for Excel the right way?

May 16 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On May 16, 2:36 pm, nofear <euroli...@hotmail.comwrote:
I used to export my reports as snapshot but now I have to export them
to Excel
When I export my report to a Excel Spreadsheet the report header and
footer are not included
Only the data gets exported.

How do I format a Access report for Excel the right way?
Design a query that returns the data you want and TransferSpreadsheet
that query.

May 17 '07 #2

P: n/a
It appears that when you export to Excel, CSV, etc you won't be able
to export header / footer information.

I know this is not very elegant: You can export a report to RTF and
then copy the content and paste it on an excel spreadsheet; this would
give you roughly what you are asking for.

But I imagine the reason you would like this in excel is to perform
data analysis on the spreadsheet - if this is the case then the
footers at the end of each page will not allow you to do filtering of
the data properly.

Perhaps and idea would be to provide a report in RTF format and then
embed the excel version on the RTF format so that the recipients of
the report could (a) look at a nicely formatted report and (b) click
on the embedded excel file to perform data anlysis.

HTH
May 17 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.