Maximum number of rows?

  • Thread starter Thread starter Jaime H
  • Start date Start date
J

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,
 
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.
 
Back
Top