I'm drawing a blank here. I had a few options around this in 2003 but cannot seem to figure it out in 2007.
I have a database that I'd like to import into excel to run some daily reports.
By default Access uses the field name as the column header. I have entered my customer column names in the caption fields for each column. When I perform the query in Access the column headers are named the same as what I have entered into the caption field. When I then import that database into excel it changes back to naming the columns headings with the field name.
I can either have set column headers and import my data without the column names or somehow import the customer names with my data into excel. Anyone have steps on doing either of these?
Thanks
I have a database that I'd like to import into excel to run some daily reports.
By default Access uses the field name as the column header. I have entered my customer column names in the caption fields for each column. When I perform the query in Access the column headers are named the same as what I have entered into the caption field. When I then import that database into excel it changes back to naming the columns headings with the field name.
I can either have set column headers and import my data without the column names or somehow import the customer names with my data into excel. Anyone have steps on doing either of these?
Thanks