Importing from Excel to Access

A

accessunknown75

What is the maximum number of records allowed to be imported from Excel into
Access?
 
D

Douglas J. Steele

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.
 

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
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Can activities be imported with their relationships? 0
Integrating information from Word to Excel (not mail merge) 1
Merging from an Excel file with graphics 1
some records will be imported from excel 0
Booklet in Word, Merge Directory from Excel 0
Import Excel 2010 table into Access 2010 - not listed as range 0

Top