Maximum number of rows in one table of Access 2000

M

Manish Patel

Does anyone know what is the maximum number of rows that a
table in MS-Access database can hold? We are on Access
2000 and we need a table to contain 95000 rows.

However, we get an error when we try to upload more than
62249 rows in one table.

Any help is appreicated.

Regards,
Manish Patel
 
J

John Nurick

Hi Manish,

There's no specific limit, and tables with millions of rows are not
uncommon. There is however a limit of 2GB on the size of an Access 2000
(or later) mdb file.

How are you "uploading" the data and what error are you getting?
 

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

Max. # of rows in a worksheet 2
Import Data from Excel - Size Limits 4
TransferDatabase ToSQL 6
Access counts blank rows in Excel rows as records in linked table 1
Question on the occupied field of the pivot table in excel spreadsheet 0
Access import from Excel - Append & Update simultaneously 1
Maximum Rows for a table 5
what is the maximum number of rows when exporting query to excel 3

Top