Move More Than One Million Access Rows to Excel
Question details
The user needs to work with an Access table that contains more rows than fit on one Excel worksheet.

- Product
- Microsoft Access and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Moving a large Access table to Excel for analysis or reporting.
- Observed behavior
- An Excel worksheet is limited to 1,048,576 rows, so the entire table may not fit on one sheet.
Check your Office version and count the records in the Access table. In Excel 2007 and later, a worksheet holds 1,048,576 rows, including any header row; older versions have lower limits.
Split Access data into separate Excel workbooks
Use saved Access queries to export manageable, nonoverlapping portions of the table.
If the first worksheet row contains field names, export no more than 1,048,575 data records to each sheet. Using separate workbooks avoids relying on an export to append sheets to an existing file.
Open the table in Access and identify a field, such as a numeric ID, that you can use to divide records into nonoverlapping groups.
Select Create > Query Design, add the table, and enter criteria for the first ID range. Save the query, then create additional queries for the remaining ranges.
Run each saved query and check its record count. Adjust the ranges if any result exceeds the available Excel data rows, and account for records with blank partition values.
Select a saved query in the Access navigation pane, choose External Data > Excel, and export it to a new .xlsx file. Repeat with a different file name for each query.
Open the exported files in Excel and compare their row counts and ranges with the Access query results to confirm that all records were included once.

Keep the full dataset in Access and analyze it in Excel
Use filtered queries, summaries, or a PivotTable when you do not need every record on a worksheet.
Review exported Access data with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel exports in WPS Spreadsheet to review and work with split datasets as you migrate your workflow.

Frequently Asked Questions
How many Access records fit on an Excel worksheet?
Excel 2007 and later allow 1,048,576 rows per worksheet. If row 1 contains column headers, up to 1,048,575 rows remain for records.
Can I export a large Access table to more than one file?
Yes. In Access, create saved queries with nonoverlapping criteria, then select each query and use External Data > Excel to export it to a separate workbook.
How can I analyze the data without exporting every row?
Create a filtered or grouped query using Access's Create > Query Design. Connect to that query from Excel's Data tab, then load the smaller result or use a supported PivotTable or Data Model option.
Does the Excel Data Model remove the worksheet row limit?
No. The worksheet limit remains in place, but supported Excel versions can use the Data Model to analyze data without putting every source row on a worksheet. Capacity depends on the version and available resources.




