31532 Microsoft Access was unable to export the data RRS feed

  • 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!!

    Saturday, April 29, 2017 7:15 PM

All replies

  • Will work if you remove the constant acSpreadsheetTypeExcel9.
    Sunday, April 30, 2017 9:51 AM
  • 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.



    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 MSDNFSF@microsoft.com.

    Monday, May 1, 2017 7:17 AM