Export Access Report to Excel - No Data

[Guest]

Hi, I have an Access report, which contains detail and a "project" group
footer. I hide the detail and just see the footer data in the report. I
want to export this data to Excel, but when I do all that shows up in Excel
is 1 row with the words "text x" (where x is a number), in cells across the
top. No data.

I have Access 2000. I can export it to rtf or to csv, but not to excel. Is
there a way around this?

TIA

 

[Guest]

Footers are not exported to Excel from reports - only headers are. Move
everything from the footer and add it to the same group's header.

The "Text xx" are the names of your text boxes that your values are stored
in on the report. Change the names of your text boxes to something
meaningful that will become your header in the Excel Report.

HTH
Bryan

 

[Guest]

Bryan - thank you so much! I could not find any other reference to the
information you provided, which was/is invaluable to me.