Maximum Table size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
If my memory serves me well the size limit of an access db is 2 GB.

Best regards Paolo
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Parts for my new build 10
Acoustics - 80Hz loss in car! 0
Ms Access size? 2
Add autonumber to a large table? 0
Maximum virtual memory size 3
Excel Returning Multiple Results (closest Match Not Exact) From A Table Using Multiple Criteria 1

Back
Top