Data Import & Export

Move More Than One Million Access Rows to Excel

Khadija KhanKhadija Khan Nov 20, 2026 869 views

Question details

The user needs to work with an Access table that contains more rows than fit on one Excel worksheet.

How to Move More Than One Million Access Rows to Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Choose a partition field

Open the table in Access and identify a field, such as a numeric ID, that you can use to divide records into nonoverlapping groups.

2
Create a query for each group

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.

3
Check the query results

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.

4
Export each query

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.

5
Verify the exports

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.

Split Access data into separate Excel workbooks
Free Microsoft Office alternative

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.

Open compatible Microsoft Excel .xlsx workbooksReview Access data exported into separate workbooksWork in a familiar, easy-to-use spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

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.