How to Fix Microsoft Access Runtime Error 2587 When Exporting Reports to Excel
Question details
Users are encountering a runtime error when attempting to export reports from Microsoft Access to Microsoft Excel.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Exporting database reports to Excel or utilizing the TransferText VBA feature.
- Observed behavior
- Microsoft Access displays Runtime Error 2587 with the message 'Cannot complete the output operation.' Exporting to formats like PDF, RTF, or TXT may continue to function correctly.
Ensure you have an active internet connection to download the necessary Microsoft Office updates, and save any open tables or forms in your Access database before proceeding.
Install the Latest Microsoft Office Update
Updating Microsoft Office is the most effective way to permanently resolve Error 2587, as the issue stems from a known bug in a previous security update.
This export error is a recognized issue linked to a recent Office security update affecting both Office 2016 and Microsoft 365 installations. Microsoft has deployed a fix for this bug in the Current Channel Version 2206 (Build 15330.20264 or later).
Launch Microsoft Access, click on the 'File' tab in the top-left corner, and select 'Account' from the left-hand navigation pane.
Under the 'Product Information' section, click on the 'Update Options' drop-down button.
Select 'Update Now'. Allow Microsoft Office to download and install the latest patches in the background.
Once the update is complete, close and reopen Microsoft Access, then try exporting your report to Excel again.
Export to Alternative Formats
If you cannot immediately update Microsoft Office, use alternative text-based formats as a temporary workaround to extract your data.
Process Your Exported Access Data Seamlessly with WPS Office
If Access Error 2587 prevents you from exporting directly to Excel, you can export your reports as CSV or TXT files and easily analyze them using WPS Office. As a powerful, free alternative to Microsoft Office, WPS Spreadsheet handles large datasets effortlessly and offers comprehensive data analysis tools.
- 1. Open WPS Spreadsheet: Launch the WPS Office suite and open a new Spreadsheet workspace.
- 2. Import Exported Data: Go to 'Menu' > 'Open' and locate the CSV or TXT file you exported from Microsoft Access.
- 3. Save as Excel Format: Use 'Save As' to easily convert your data into a standard .xlsx workbook for further distribution or analysis.
Frequently Asked Questions
What causes Microsoft Access Runtime Error 2587 during export?
This error is predominantly caused by a bug introduced in a previous Microsoft Office security update. The update breaks the background mechanism Access uses to pass output data to Excel and triggers the 'Cannot complete the output operation' message.
Does Error 2587 affect the TransferText VBA feature?
Yes, the bug that prevents manual exports to Excel is known to simultaneously disrupt the TransferText VBA feature and manual text transfers in Microsoft Access. Updating your Office installation resolves both issues.
Are older versions of Microsoft Office affected by this error?
The issue has been widely reported on both Microsoft Office 2016 standalone installations and subscription-based Microsoft 365 environments. Ensuring your specific build is updated past Version 2206 (Build 15330.20264) is the recommended fix.
Why does exporting to PDF still work when Excel export fails?
Access utilizes different rendering and output pipelines for fixed-layout formats like PDF and RTF compared to dynamic spreadsheet formats like Excel. The security update bug specifically interrupted the data handoff sequence used for Excel.
