What is the maximum number of records allowed to be imported from Excel into Access?
A accessunknown75 Jan 20, 2005 #1 What is the maximum number of records allowed to be imported from Excel into Access?
D Douglas J. Steele Jan 20, 2005 #2 Access doesn't have a limit on the number of rows: the only limit is on the total size of the MDB file. The most recent version of Excel can only handle 65,536 rows, so that would seem to be your limiting factor.
Access doesn't have a limit on the number of rows: the only limit is on the total size of the MDB file. The most recent version of Excel can only handle 65,536 rows, so that would seem to be your limiting factor.
