Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Data connections properties "include/exclude column headings" option for
importing data from Access to Excel is missing in the new 2007 version. I have many Excel spreadsheets that import data from Access and the 2003 version shows this option when creating a new connection, but the 2007 version does not have it. Existing 2003 spreadsheets show the option when opened in 2007, but as soon as a new connection is made to add columns, it disappears. Since column headings have been customized and adjusted from access, I need to keep the Excel headings by "Excluding" the import of column headings. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column Data to Appear as Column Headings in Another Sheet | Excel Discussion (Misc queries) | |||
Worksheet has numeric column headings. Change to alpha headings? | Excel Discussion (Misc queries) | |||
How can I include file properties in an excel spreadsheet | Excel Discussion (Misc queries) | |||
How to keep column headings from being sorted with data? | New Users to Excel | |||
AutoSum macro that doesn't include headings | Excel Programming |