Changing Header exported to Excel

[Adam_needs_help]

I am exporting tables to excel and it automatically makes the header in the
excel file the table name. I want to be able to add something to that
header.

For example if the table name is "ABC" I want the header in excel to be "ABC
Delicious"

I want this to happen automatically (so it can be part of a macro) as I am
exporting many tables on a daily basis.

Thanks.

 

[Justin]

Use a query to export the data instead of the table and create the field
headings you want.

 

[Adam_needs_help]

I don't think I was clear. I am talking about sheet header, not column
headings. So I want to be able to change the sheet header. Hopefully that
makes sense.

 

[Roger Carlson]

Actually, the same way. Create a query named whatever you want the sheet
tab to be named. Export the query instead of the table. You can then
reference the sheet tab in your header.