| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retain table column titles in 2007
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retain Column Width | Excel Discussion (Misc queries) | |||
| Why won't the copy/paste from PDF retain the row/column in excel? | Excel Discussion (Misc queries) | |||
| Move Column Retain Formula | Excel Discussion (Misc queries) | |||
| URGENT! Retain format of cells in pivot table upon refresh | Excel Discussion (Misc queries) | |||
| how do I keep column titles on subsequent pages of a pivot table | Excel Worksheet Functions | |||
Linear Mode
