Maximum Number of Columns-Rows in Access Table

  • Thread starter Thread starter ChelleV
  • Start date Start date
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!
 
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

Maximum Columns in Table 10
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Maximum capacity (Mb) or number of rows 2
Limit on number of fields in MS Access forms 3
Maximum Row Number 4
Table Row Limit Size? 14
Maximum Columns in a table in Access 2
Number of characters in a table name 11

Back
Top