Integration crashes after Office upgrade from 2013 to 2016

(0) Share

Report

Posted on by Community Member

GP 2016 / Integration manager crashes on preview of excel source, does not on text files. So basically excel related matter. Integrate says can't read excel file

The server was upgrade from office 13 to 16 yesterday and trouble begins today. Anyone seen that before ? It'll be rebooted in 2 hours to retry.

Very weird.

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Community Member on at

Like (0)

Report

RE: Integration crashes after Office upgrade from 2013 to 2016

No, both version are 64 bit.

So it turns out to be xlsx vs xls.

The integration using xlsx uses the Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, couldnt see the rest) will crash on xlsx file - Ill call this multi driver since it supports multiple format

I switch it to Microsoft Excel Driver (*.xls) only and convert xlsx into xls file has no issues.

I just did a test, using object browser and going to source adapter, simple odbc that uses the multi excel driver with a xlsx in config crashes

BUT !

Using excel multidriver on xls files works, no crashes, nothing. It just does not like XLSX files.

Its a workable solution.. not many xlsx files.. xls works fine
Mike Bufano 1,482 on at

Like (0)

Report

RE: Integration crashes after Office upgrade from 2013 to 2016

is the version of office 2013 32 bit?

Is the version of office 2016 64 bit?

If the office version changed from 32 vs 64 then that may be the answer.

regards