Link an excel sheet starting at a specific row 1

[yoshi88]

Hi,

I would like to know if it is possible to link an Excel sheet in Access without the first 4 rows. I have an excel file wich is use by many users with the header in row 5 and when I link it to Access, the names of the fields change if the first row of the Excel sheet changed.

Thanks

Frank

 

[Remou]

You can, for example:

[tt]DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel9, "tektips", "tek-tips.xls", True, "a5:b7"[/tt]

 

[yoshi88]

Thank you for this fast answer, it's working perfectly.

Frank