importing excel worksheet-records different

  • Thread starter Thread starter joe
  • Start date Start date
J

joe

I am importing an Excel97 workshet into Access97 that has
approx 57000 records that is laid out in 24 fields on the
spread sheet. After importing into Access, I end up with
16383 records not the 57000 I am expecting. I guess it
must be that the fields are mostly text fields eating up
254 characters each and thus it is too much data? I do not
know what to do. Where am I missing the boat anyone.
Thanks.
 
As I recall, A97 and Excel97 when working together limited data by default
to 16,000 rows or so.

You may be able to use TransferSpreadsheet and change the default version of
Excel from 5 to 97 and then it may work correctly. If not, then an upgrade
to Office2000 or newer should solve the problem. Or else you can split the
data into multiple sheets of 16,000 rows each.
 
Back
Top