Linking Tables from Excel

[tlaksh]

Is there a limit on how many records a access database can hold?. I tried to link and import a excel file with 50000 rows and all I can see in access is 16383 rows.

Please help...I am using Access 97

 

[koresnordic]

Extract from a thread I posted a while ago as thread thread702-454980 . Reply from evalesthy:
Attribute Maximum
Microsoft Access database (.mdb) file size 2 gigabytes. However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255


This was for Access 2000, so the limits on 97 are probably less.

Graham

 

[Clundey]

Problem may be with excel xls files. They are limited to 16383 rows. csv files have no restriction.

Had this problem myself a long time ago!

Cheers

Chris