Exporting a access report to Excel spreadsheet

[nofear]

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?

[DavidB]

On May 16, 2:36 pm, nofear <[e-mail]:

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.

[Max Vit]

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