How many lines can Access handle?

D

DJ

I am trying to find out how many lines Access can handle.
Excel only handles 65,000, but I have 10 times that many.
 
C

Cheryl Fischer

There is no limit to the number of records an Access table can hold, as long
as the size of the database itself (MDB file) does not exceed 1 GB for an
Access 97 database or 2 GB for an Access 2000 (or newer version) database.
 
J

John Vinson

I am trying to find out how many lines Access can handle.
Excel only handles 65,000, but I have 10 times that many.
Click to expand...

A 20,000,000 row Table is getting pretty large. 650,000 should be no
problem.

Do note that a Spreadsheet and a Database are TWO VERY DIFFERENT
OBJECTS. Treating Access as a "big version of Excel" will get you into
some *real* design problems!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coping files from Access DB to an Excel Spreadsheet 6
splitting a large access table to export to excel 2
Access export to Excel stops at about 45,000 not 65,000 XL limit 11
Understanding Many-to-Many Relationship 4
Export to Excel more than 900,000 records 2
opening file with over 65000 records 7
File size in Access 2003 3
Cells with varying number of lines 1

Top