Occur ODBC error when the vsd file exports to Ecxel file

坂本 皐 5 Reputation points
2023-12-12T02:52:51.96+00:00

I tried to export a vsd file using Visio's Database Export Wizard to excel.

However, I got the following ODBC error.

User's image

It says ODBC Excel Driver s1004 error, what part of the configuration causes this error?

I do not change configs from default in the Database Export Wizard.

Thanks in advance.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,349 questions
Visio
Visio
A family of Microsoft products used to create diagrams and vector graphics.
78 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 22,236 Reputation points Microsoft Vendor
    2023-12-12T08:22:32.52+00:00

    Hi,

    Based on the error it seems the data type is not allowed.

    I suggest you try to create a simple file and check if you can export without problem.

    Try to test and let me know the result, I am glad to be of assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.