TransferSpreadsheet method omits last row if there are headers

[PCX]

My spreadsheet is about 250 rows. If I use the TransferSpreadsheet command and the Excel file has headers the data is added but the last row is missing.

I use a work-around by adding the last row twice at the bottom and it works fine but is difficult to get a user to know how to do this.

Is there a better way to use VBA to do this.
Or am I just missing something?

This is the code:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "tblName", sFile, True

Thanks

 

[Andrzejek]

Would this help - TransferSpreadsheet - Range until EOF?

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson