Importing Excel sheet

  • Thread starter Thread starter Oded Kovach
  • Start date Start date
O

Oded Kovach

Hello there

I have excel sheet the i need to import it to access by code

For this i use DoCmd.TransferSpreadsheet

The problem is that on one of my files i have excel heading that cannot be
field name on access

When i use the wizart it gives me an option not to use excel headings and
that i works.

Is there a way in code to do the same in the wizert that not to use first
line in excel file as field names?

any help would be useful
 
The fifth argument of the TransferSpreadsheet method is HasFieldNames. Set
it to False to indicate there aren't any.
 
Back
Top