Maximum Table size

G

Guillermo

Is there a max no of rows or a max physical size in gigabytes for an Access
table?
I have a static text file with 12 million rows and 23 gb in size. Can I load
this into Access?
 
P

Paolo

If my memory serves me well the size limit of an access db is 2 GB.

Best regards Paolo
 
R

Rick Roberts

You are most definately outside the range of Access/Jet MDB. With 12 million
rows and 23 gb of data you need to look at SQl Server or Oracle.
 
Top