Data Import & Export

Export More Than 100,000 Access Records to Excel Without Clipboard Errors

Camila MilosovichCamila Milosovich Nov 20, 2026 868 views

Question details

Export more than 100,000 filtered Access records to Excel without encountering a clipboard record limit.

Export More Than 100,000 Access Records to Excel Without Clipboard Errors
Product
Microsoft Access and Microsoft Excel
Device & OS
not provided
Scenario
The user needs to export a large filtered Access table to an Excel workbook.
Observed behavior
Access reports that too many records were selected for the clipboard when the user tries to export the filtered datasheet.
Before you start

Identify the table, fields, and filter criteria used in the datasheet, and choose a writable location for a new .xlsx file. Ensure you can run VBA in the Access database.

Solution 1Recommended

Export a saved Access query with TransferSpreadsheet

Use a saved query to apply the filter and export its results without copying records through the clipboard.

1
Create a saved query

In Access, select Create > Query Design and save a select query named qryExport. The VBA example below replaces its SQL before exporting.

2
Add the export procedure

Press Alt+F11, select Insert > Module, and add this procedure: Sub ExportFilteredRecords() Dim outputPath As String outputPath = "C:\Exports\AccessExport.xlsx" CurrentDb.QueryDefs("qryExport").SQL = "SELECT * FROM tblScope WHERE Plant='56'" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "qryExport", outputPath, True End Sub

3
Adjust the query and path

In the VBA editor, replace tblScope, Plant, and '56' with your table and filter criteria, and set outputPath to a new .xlsx file in an existing writable folder. The example assumes Plant is a text field; use syntax appropriate to your field type.

4
Run and verify the export

Place the cursor inside ExportFilteredRecords and press F5. Open the resulting workbook in Excel and check that the expected filtered records and column headers are present.

Export a saved Access query with TransferSpreadsheet
Match the original filter: The query must explicitly reproduce the datasheet filter; it does not automatically inherit the filter from an open table. TransferSpreadsheet exports the data, so apply any additional formatting in Excel afterward.
Free Microsoft Office alternative

Review Exported Access Data in WPS Spreadsheets

After exporting from Access, open the workbook in WPS Spreadsheets to review and format the results. WPS Office is a free, lightweight alternative with a familiar interface and compatible Office formats for an easy transition; it does not fix the Access clipboard error itself.

Review and format exported Access records in a spreadsheetOpen and edit Microsoft Excel .xlsx and .xls filesUse a familiar spreadsheet interface with a free, lightweight office suiteMove existing Office workbooks into your WPS workflow
microsoft office alternative - wps office

Frequently Asked Questions

Why does exporting a saved query avoid the clipboard error?

DoCmd.TransferSpreadsheet exports the saved query's results directly to a workbook rather than copying the selected datasheet records through the clipboard.

Will the saved query automatically use my current datasheet filter?

No. Edit the query in Create > Query Design or update its SQL in VBA so its WHERE clause matches the filter you want to export.

Can Excel hold more than 100,000 exported records?

Yes. An Excel worksheet supports up to 1,048,576 rows, including the header row. Larger exports must be split across worksheets or files.

How can I format the exported workbook?

Open the .xlsx file in Excel or WPS Spreadsheets and apply the desired formatting. For repeatable formatting in Excel, you can use Excel automation after the Access export.