Import excel into access starting at specific row

[mmogul]

I have another application that exports its data into excel. But the headings start on row 3 and the data on row 4. What is the best way to import this data into an access table?

 

[lameid]

A solution is to specify the range. This works best with a named range but assuming you are importing from Excel 2003 the following example ought to work out....

docmd.TransferSpreadsheet acImport,acSpreadsheetTypeExcel9,"Temp","C:\temp.xls",Yes,"Sheet1!A3:X65536"

 

[mmogul]

Thanks for your help.