ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data connections properties include column headings (https://www.excelbanter.com/excel-programming/436947-data-connections-properties-include-column-headings.html)

RANDL WHEAT

Data connections properties include column headings
 
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.


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com