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.
 
Back
Top