Export More Than 100,000 Access Records to Excel Without Clipboard Errors
Question details
Export more than 100,000 filtered Access records to Excel without encountering a clipboard record limit.

- 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.
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.
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.
In Access, select Create > Query Design and save a select query named qryExport. The VBA example below replaces its SQL before exporting.
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
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.
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.

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.

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.




