How many rows of data can Access hold?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am designing an access db and I am going to import data files into access
tables. i am not sure how many rows of data can an access table hold. I am
looking at importing around 250,00 rows of data into one table. I know how
to link tables I was just curious if there is a certain number of rows that
can be imported without access failing to import or retrieve the data.
 
There is no limit on the number of rows, just on the size of the file. Go
to Help and type "specification" for more details. (Someone went through a
lot of trouble to write those help fiels).

Rick B
 
I have sucessfully imported over 2.5 million rows into one Access table.

I hope that helps

Jim
 
PAS said:
I am designing an access db and I am going to import data files into
access tables. i am not sure how many rows of data can an access
table hold. I am looking at importing around 250,00 rows of data
into one table. I know how to link tables I was just curious if
there is a certain number of rows that can be imported without access
failing to import or retrieve the data.
Click to expand...

Actually Access has records not rows, like Excel.

The limit in Access is one Gig for the whole file in version 97 and
prior and two Gig in more current versions of access. That can be a very
large number of records. Much larger than Excel can handle.
 
There is no limit on the number of rows. The limit is the size of the MDB.
2G.

HTH
 
Back
Top