While working with a Microsoft Access database and exporting a table with more than 65,000 records, you may receive the following error message:
You selected more records than can be copied onto the Clipboard at one time. The maximum number of records that you can paste at one time is approximately 65,000
This error is often caused by using the following code syntax:
DoCmd.OutputTo acOutputQuery, "qryName", acFormatXLSX, Application.CurrentProject.Path & "\ExportName.xlsx", True
Try changing the code to the following and your error should be a thing of the past:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qryName", Application.CurrentProject.Path & "\ExportName.xlsb", True
If you need any help implementing any of these code samples
or modifications made for your needs, please
Click Here to get a free
quote for your Microsoft
Access Development needs.
Click Here to learn more
about the WSI quoting
process.
Click Here to view some other common Microsoft Access Run-Time Errors.