![]() |
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