Exporting to Excel - Column Headers

[Xarkath]

Hello,

I have a report in Access that produces variable headers as the output is different from client to client. When exporting to PDF everything works great but when exporting to Excel these variable headers are exported with thier true names. Col8, Col9, Col10 etc. And our clients insist on Excel reports. Is there a way to get the assigned name to export to Excel? Assigned names would be something like Medical, Dental, Vision or whatever is applicable to the client and is assigned to the report through VBA code. BTW, the data for the report is pulled from a cross-tab query so exporting directly from the query has its own set of formatting issues and is the reason I am using a report with variable column headers.



Thanks

[rpeare]

you can export data to an excel file on a line by line basis (i.e. cycling through a crosstab query and exporting it line by line rather than trying to export the thing as a whole might work)

http://www.homeandlearn.org/write_to_a_text_file.html

it's exporting form an excel file to a text file but the same methodology would apply to exporting from access. (you can get query column counts and row counts for instance)

[rpeare]

oh, one other thing you could try... append the crosstab query to a temporary table, then export the contents of the temporary table. I am not a proponent of using temp tables but exporting crosstabs is one of the times where it's expedient.