Importing Excel File with VBA without headers and skipping first 3 rows

[jstevens]

I'm sure this is easy, but I can't seem to find a way to do this. I'm very new to Access, so appreciate any help. Basically I want to import an excel file that doesn't have any column headings and the data starts on row 4. I already have a table with all of the column headings set in Access.

My research led me to create an import specification and then edit that in the 'mSysIMEXSpecs' Table to Start on Row 4 and then use that spec in VBA to transfer the file to my table. That all seems good, but it seems like an Import Spec only gets saved to the 'mSysIMEXSpecs' Table if you are importing a text file. Nothing gets saved there for Excel.

Any help is appreciated.

Thanks,
Jason

 

[llkhoutx]

You have to import all the rows. A header is optional.

 

[kevlray]

I have not used it. But it appears that DoCmd.TransferSpreadsheet will let you specify a range (Named Range?). Lots of luck.

 

[jstevens]

Thanks kevlray. I was able to specify a range and that did the trick.