Solved Importing excel with 140k records (1 Viewer)

[Number11]

I am using this to import data into a table, however its not importing all records it only import the first 63,500 records, the spreadsheet has 145,000 Records

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12Xml, "Table1c", strFileName, True, "A:AF"

So is there a work around to import all records?

 

[Minty]

Try removing the range on the end, which has been known to be troublesome.

 

[Gasman]

I'd start here here?

 

[Number11]

Try removing the range on the end, which has been known to be troublesome.

Yes that worked