How many rows of data can Access hold?

[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.

 

[Rick B]

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

 

[Jim]

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

I hope that helps

Jim

 

[Joseph Meehan]

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.

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.

 

[Larry Daugherty]

There is no limit on the number of rows. The limit is the size of the MDB.
2G.

HTH