Rename fieldName and keep Excel sheet when exporting data

[Guest]

I am working on a database that has linked tables, where the fields have
captions. I need to rename the fields, but I am not sure how.

When I create a query to be exported to Excel, and use "newFieldName:
table.fieldName" the table's caption appears. Is there a way to rename the
field in the query before I export the data into Excel or just rename the
field somehow?

Also, when I export a query into Excel, is there a way that I could keep the
formatting that is in Excel (just export data)? The people I am helping would
like to keep the format since they are used to it.

 

[John Nurick]

Either remove the captions from the table fields and alias the names in
the query as you are doing now, or add captions to the fields in the
query (in Query Design view, right click on a field and select
Properties).