How to retain table column titles in 2007

J

JohnS

How do I retain my column titles in an Excel 2007 table?

I'm loading data to an excel 2007 table using ms query and ODBC. The SQL
uses outside joins to 4 tables so ms query will not retain the assigned
column names. On every refresh, my excel column titles are overwritten with
the SQL field names.

I don't see a way in Excel to force the table to keep my column names or a
way to force ms query to retain my column name assignments (I tried "as
<ColumnName>" with double quotes, single quotes, and no quotes)

Thx for any insight.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtotals in Excel 2007 0
Excel 2002: How to retain default formating after pasting ? 12
How can I not overwrite my column headers when I do an ODBC refres 2
external data table sort order 0
Rename imported MS Access field names 1
Adding a column to an Excel table 2
How can I set up multi-row column titles in Access 2007? 1
Columns following the Row in an Imported Table 0

Top