TransferSpreadsheet limited to 253 rows?

[GoodOmens]

I'm having a strange error when importing a big spreadsheet with Access.

The excel spreadsheet has around 5300 rows and I am using to following command to import:

DoCmd.TransferSpreadsheet acImport, 8, "portal_sgn", "U:\old_users\portal_sgn.xls", True, "B2:E"

When I try this it only imports 253 rows. However if the excel spread sheet is open during the import everything gets imported correctly.

I've tried moving the excel file around to a local drive (as oppose to the network drive) and get the same result.

Any suggestions?

 

[petehilljnr]

What about if you delete the first say 255 rows and try then?
Maybe a line of data is throwing it?