Maximum Number of Columns-Rows in Access Table

C

ChelleV

Where can I find, or does someone know, the maximum number
of columns and rows allowed in an Access Table? Is there
a limitation on the size of a text file that can be
imported into Access? Thank you in advance for your time!
 
K

Kevin3NF

see specifications in Access help. 255 columns, no explicit limit on rows.
Max file size for Access 2000 and up is 2GB. Due to overhead, I doubt
seriously if you could import a 2GB text file. Maybe a quarter of that at a
time....<guessing>

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
 

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

Autonumber field in Excel that behaves the same as Access 0
Repeating a row other than the 1st row as the header row in a table from next page 1
Copy addition formula of non-consecutive horizontal cells 2
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Limit on number of fields in MS Access forms 3
Excel does not accept text format! 0
Delete all data after a symbol in a field 0
Word VBA - Automatic change content of a cell in table using dropdown list 5

Top