31532 Microsoft Access was unable to export the data

Question

I just recently upgraded to Access 2016.

I have been exporting a query to Excel with no problem using the following statement:

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qryName", "file.xls", True

After upgrade I'm getting the error in my title.

Any ideas?

---

Thanks for your help!!

Answer 1

Will work if you remove the constant acSpreadsheetTypeExcel9.

Answer 2

Hi plynton,

I find that this error occurs due to corruption.

it is possible that when you had install the Access 2016.

at that time installation not done successfully or correctly.

and cause this issue.

try to repair the MS Office or try to reinstall it.

try to run the same line of code and check whether your issue is solved or not.

for further reference you can visit link below.

How To Fix Microsoft Access Error 31532

DoCmd.TransferSpreadsheet Method (Access)

let me know about your testing results, so that I can try to provide further suggestions if needed.

Regards

Deepak

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].