Home > OS >  Can't export report to .xls anymore in MS Access?
Can't export report to .xls anymore in MS Access?

Time:07-20

I usually right click -> export report as .xls to a directory but lately it hasn't worked, giving the error:

Microsoft Access can't complete the Output operation.

The visual basic code you entered contains a syntax error or the Output procedures are not available.

Make sure there isn't a syntax error in your code. if the syntax is correct, run Setup to reinstall Microsoft Access. If you want to preserve your security or custom settings, back up the Microsoft Access workgroup information file. For information on backing up files, search the Microsoft Windows Help index for 'backing up files'.

(Error code 2587)

This happens no matter what I try to export. Is there a workaround or fix?

CodePudding user response:

We ran into this one today too, with the same symptoms and error message. Completely uninstalling and reinstalling Office Access resolved it.

CodePudding user response:

Have also run into this problem today. The following article

https://answers.microsoft.com/en-us/msoffice/forum/all/ms-access-cant-complete-the-output-operation/882ee01c-3e12-45df-8c22-ed73aa043c48?page=2

suggests it's specific to build 15225.20292

and it should be fixed if you run MS Updates and get the latest build installed which is 15330.20204

https://support.microsoft.com/en-us/office/what-s-new-in-microsoft-365-95c8d81d-08ba-42c1-914f-bca4603e1426?ui=en-us&rs=en-us&ad=us

Hope that helps!

CodePudding user response:

I was having the same issue. Updating Access to build 15330.20264 was the key.

  • Related