Fix Microsoft Access Importing Only 25 Rows from Excel
Question details
The user needs to import all records from an Excel file into Microsoft Access rather than only 25 rows.
- Product
- Microsoft Access and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Importing an Excel worksheet containing more than 25 records into an Access table.
- Observed behavior
- Only 25 rows appear to be imported, although the source workbook contains additional records.
Identify whether you are using the Access import wizard or copying and pasting Excel cells, and count the expected data rows without the header. Note the source worksheet or named range and any error messages shown during the import.
Import the complete worksheet with the Access import wizard
Use this method when a partial cell selection, a short named range, or the wrong worksheet may be limiting the import.
Microsoft Access does not normally impose a 25-row limit on Excel imports. Filters and hidden rows are worth checking when reviewing or copying the source, but they do not necessarily restrict a worksheet import through the wizard.
Open the workbook in Excel and select the worksheet containing the records. Use Data > Clear to clear active filters, and unhide rows if necessary so you can inspect all records. Confirm that the rows beyond row 25 contain actual data.
If you are importing a named range, open Formulas > Name Manager in Excel and inspect its Refers to field. Expand it to include every required row, or choose the full worksheet during the Access import. Save and close the workbook.
In current Access versions, select External Data > New Data Source > From File > Excel. In older versions, use External Data > Excel. Browse to the workbook, choose Import the source data into a new table in the current database, and select OK.
In the import wizard, select the worksheet or corrected named range. Set First Row Contains Column Headings according to your file, review the field settings, and complete the wizard.
Open the imported table directly in Datasheet View rather than viewing it through a form or query. Clear active filters with Home > Advanced > Clear All Filters, then compare the table's record count with the expected source count.
Check import errors and test the data in a new Access database
Use this method if the complete source is selected but records are still missing, especially when appending to an existing table.
Prepare Excel Import Data with WPS Spreadsheet
WPS Office is a free, lightweight alternative for everyday Office document work, with a familiar interface and support for Excel files that makes migration straightforward. Use WPS Spreadsheet to review and prepare your source workbook before importing it with Microsoft Access; WPS does not repair Access or replace its database import tools.
Frequently Asked Questions
Does Microsoft Access limit Excel imports to 25 rows?
No. A consistent 25-row result points to a source selection, named range, display filter, or import problem rather than a normal Access limit. Use External Data > New Data Source > From File > Excel to import the complete worksheet into a new table.
Can hidden or filtered Excel rows explain missing records?
They can affect what you see or copy, especially if you copy only visible cells. A worksheet import through the Access wizard is not necessarily limited by Excel's visible rows. Clear filters in Excel with Data > Clear and inspect hidden rows to confirm the source actually contains the expected records.
Why do all rows import into a new table but not an existing table?
An existing table may reject records because of duplicate primary keys, required fields, validation rules, or incompatible field types. Right-click the destination table in the Access Navigation Pane, select Design View, and compare its field properties with the source data.
How can I tell whether the records were imported but are not displayed?
Open the destination table directly from the Access Navigation Pane. In Datasheet View, use Home > Advanced > Clear All Filters and check the record count. A form or query can display fewer records because of its own filtering or query conditions.
Do I need to upgrade Microsoft Office to import more than 25 rows?
A 25-row result alone does not indicate that an upgrade is required. First test the workbook through the import wizard in a blank Access database and review any errors. Access 2007 is out of support, but that does not establish it as the cause of this specific import result.
