View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Hudson Ken Hudson is offline
external usenet poster
 
Posts: 186
Default Importing Excel Workbook into Access

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