Column headings reverting to field names when exporting to Excel

[Ben]

Hi,
In my query, I have renamed each field which looks fine on the results
screen. However, when I export to Excel, the column headers revert back to
the field names. Is there a way to fix this so I don't have to rename in
Excel?

 

[John Spencer MVP]

I believe you can use an alias for the fieldname in the query and then you
will see that name used in the export. In query design view enter the name
you want to see followed by a colon in front of the current field name.
Something like the following in the Field "Cell"

MyNewName: TheRealFieldName


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Ben]

John - thought it would work, but it still shows the real field name as the
column heading in Excel.

 

[Ben]

I'm retarded. It works.
Thanks
Ben

I believe you can use an alias for the fieldname in the query and then you
will see that name used in the export. In query design view enter the name
you want to see followed by a colon in front of the current field name.
Something like the following in the Field "Cell"

MyNewName: TheRealFieldName


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County