sending Report to Excel... column headings in Excel

[marydoyle9]

There is an Access 97 Report that gets ported over to Excel. When the Excel sheet opens, soem column heading have the correct label and other columns have "Text55" or "Text29", etc.
First, how do the Excel columns get the "headers" and second, how do I change the "Text" headers to meaningful names?

Thanks!
ML

 

[IMO]

Try exporting the table or query the report is based on rather than the report itself.

IMO