Question for Access experts

basenjibabe, Mar 11, 2:49am
Question for Access experts Boss has asked me if i can find out how many records a file can hold in Access. In excel there is a limit of about 65,000 rows (?). She is importing excel data into access and can't get it to pick up all info when doing a query. Any suggestions?

lanternfish, Mar 11, 3:20am
Go to MS Office website and query ...


pdh, Mar 11, 10:14am
I didn't know... ...MS Access had a limit. You could always get Excel 2007. Has a million rows (or something like that).

oberkat, Mar 11, 10:29am
.... well, you can import dBase into Access and in dBase there's really no practical limit. But for those who INSIST on a number, it's nominally one billion records. So it may be that you'll find yourself in deep shit at one billion and one. Keep us informed . :)

guest, Apr 8, 1:18am
2G used to be the limit on the size of the .mdb, it may be or going to be 4 now, so # of rows depends on # of columns, lengths, etc.

Share this thread

Buy me a coffee :)Buy me a coffee :)