How many rows of data can Access hold?

P

PAS DESIGNER

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

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
 
J

Jim

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

I hope that helps

Jim
 
L

Larry Daugherty

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

HTH
 
Top