I have a macro that creates a workbook with column headings in row one.
Data is listed in rows two and below.
When I go into Access and import the Excel workbook, the import wizard
opens. The first screen of the wizard looks for column headers and, if Access
"senses" that headers are present, it automatically checks the "first row
contains column headers" box.
I have two workbooks that look pretty much the same to me but Accees
recognizes headers in one and not the other.
Is there some kind of formatting or other trick I can use in the Excel macro
to make Access always recognize headers?
--
Ken Hudson