Export to Excel Changing Expr1, Expr2, etc Column Heads

[jabrony76]

Hi all -

I've got a query that i've automated to export to Excel but problem is that there are computed items in this query and when I export to excel, the column heads on the computed items are Expr1, Expr2, etc, etc.

I've changed the caption of the Expr in the query but that name doesn't make it into excel upon export. Is there another property that I'm missing?

I'm using the below docmd to export to excel:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_WHC_Audit_Export", strLocation & vFileName, True

Any help would be greatly appreciated!
Thanks!
Andy

 

[jebry]

Hi Andy!

In the query design view of qry_WHC_Audit_Export your computed fields, on the field line, should read:

YourFieldName: YourComputation

That should give the fields the names you want and Access should export them to Excel.

hth
Jeff Bridgham
bridgham@purdue.edu