DIXF - The version of Microsoft Excel is not supported.

(0) Share

Report

Posted on by Rafael Araujo

183

The DIXF stopped to work on all server, I believe was some Windows Update (maybe on SQL Server 2016). Now is showing the error "The version of Microsoft Excel is not supported."

How can I fix it?

AccessDatabaseEngine_X64 is installed.

5734.Screenshot_5F00_1.png

3463.Screenshot_5F00_2.png

0636.Screenshot_5F00_3.png

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

Please have a look at the following LCS issues:

Issue 3740024"The version of Microsoft Excel is not supported" error when importing an Excel file in batch model

Microsoft has evaluated this issue, and has determined that this functionality is working as designed.

It is a limitation in SSIS.

There is a workaround for this issue.

1. Use ODBC instead of file. ODBC can be created for the excel file and then use it as source. Steps - technet.microsoft.com/.../dn144989.aspx (attached email for same).

2. Try to install this - www.microsoft.com/.../details.aspx.

Install 64-bit using command line and use /passive.

Best regards,

Ludwig

Was this reply helpful? Yes No
Rafael Araujo 183 on at

Like (0)

Report

Hi Ludwig,

I have reinstalled the Access engine 2010 using the passive command. About the ODBC, we need to use the file (CSV).

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Rafael,

Do you still receive the same error message after the reinstall or another one?

Best regards,

Ludwig

Was this reply helpful? Yes No
Rafael Araujo 183 on at

Like (0)

Report

Yes, the same error.

Was this reply helpful? Yes No
MYGz 2,164 on at

Like (0)

Report

Hi Rafael,

Go to Windows Event Viewer and check for more error details.

Was this reply helpful? Yes No
Rafael Araujo 183 on at

Like (0)

Report

Do not have nothing related with AX in Event Viewer.

Was this reply helpful? Yes No
Ajit 8,755 on at

Like (0)

Report

Is this for Import or export or both? If you not resolved it yet, can you save your excel as 97-2003 workbook and try?

Was this reply helpful? Yes No
Rafael Araujo 183 on at

Like (0)

Report

Hi Ajit,

I did, but I got the same error message. I opened a Microsoft Support Request, but the Microsoft Engineer do not solved yet. I sent a lot information and I'm waiting the solution. When I received the solution, I will update here.

Thanks!

Was this reply helpful? Yes No
Tendor 15 on at

Like (0)

Report

Hi Rafael,

Have you managed to solve the error?

I'm also strucked by the same error, and I need to used csv files in order to import the files.

Was this reply helpful? Yes No
Suggested answer

Rafael Araujo 183 on at

Like (1)

Report

Hi Tendor, the issue was in TLS Protocol. The IT disabled the TLS 1.2 and I needed to request to enabled again. After I installed an update to DIXF works with TLS 2.0.

Was this reply helpful? Yes No