R
RANDL WHEAT
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.
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.