Maximum number of rows?

[Jaime H]

Hello,

I know that there's a limit of approx 65k records in
Excel. Is there a maximum number of rows for a table in
Access? Does Access tell you when you've reached the
limit?

I am trying to import some data and want to be sure I'm
not missing anything.

Thanks in advance,

 

[Kevin3NF]

Nope. File size limit is 2GB for Access 2000 - 2003, but there is no
explicit limit on number of rows.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Albert D. Kallal]

The only limit in ms-access is the file size. So, depending on how large
each record is, that will determine the outcome.

Assuming that each recod is 200 characters long, then 2 gig/200 = 10 million
records.

Of course, if each record is only 100 characters long, then you get 20
million records.

I don't think ms-access would handle 10 million records well.

But you can certainly stuff in 1 million records.