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.
 

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
How to modify and updte specific styles for specific paragraphs across the document 0
How can the font and size of (all) citation numbers be altered? 1
Text in note pane of "normal" display suddenly much larger 1
How to paste this down? 3
Printing Outline view - formatting lost 0
Insert Index into a Table 1
cannot find which label format i need 1

Top