Exporting Access Reports to Excel with Formatting

[John Patterson]

I would like to export an Access 200 report to an Excel
spreadsheet with my column Header information above the
actual data. I have replaced my labels in the header with
text boxes, but all that produces on the spreadsheet is
another column. Any Ideas would be appreciated.

JP

 

[Gareth Grindal]

Pivot Table??
They work for me.
I found it easier to use the query that would generate my
data for the report, and dump that into a table in my
Access file.
Then use Pivottable Wizard to point to an external
datasource, and use the PivotTable functions to do the
calculations on the data.
This also allows you to dynamically control the layout of
the data.
You could then automate the execution of that query
through Excel and refresh the PivotTable to make sure you
are looking at up-to-date data.
Hope this might help
otherwise apologies for wasting your time
Gareth G