Access 97 will not import all the records from an Excel spreadshe.

[Guest]

I am trying to import an excel spreadsheet into an existing Access table.
There are approximatley 45000 records in the spreadsheet but Access is only
importing around 16000 of those records. i have not expereinced this type of
problem previosuly.

 

[Amy Vargo]

Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.
You are limited to 16,384 rows even though the maximum worksheet size for
Excel 2000 is 65,536 rows. Try importing using ranges using the
TransferSpreadsheet action if you have a large number of records to
import.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.