Occur ODBC error when the vsd file exports to Ecxel file

坂本皐 5

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.

1 answer

Emi Zhang-MSFT 24,911 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.
Please sign in to rate this answer.
坂本皐 5 Reputation points

2023-12-12T10:44:21.28+00:00

@Emi Zhang-MSFT

Thnak you for reply!

Sorry, I should attach the screenshot what the vsdx file I tried to export at least.

In fact, the vsdx file this time was a very simple with the following.

I just created this file from the "Basic Diagram".

Just to be sure, I created a similar file again and tried it again, but the same error still occurred.

I am new to Visio, so the steps to create the file may be incorrect.

If so, I would appreciate it you could tell me the correct procedure.

And, is it possible to check and change the data type settings?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer