Importing Excel sheet

[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

 

[Douglas J. Steele]

The fifth argument of the TransferSpreadsheet method is HasFieldNames. Set
it to False to indicate there aren't any.