Has anyone had any success using an Excel data source with Integration Manager 2010?
I am trying to create a simple integration with an XLSX data source. I can create the DSN for the Excel file in IM (using the ACE driver v14.00), but as soon as I select the Data Source in the Simple or Advanced ODBC Source, Integration Manager crashes.
I saw this old 2008 thread and Mariano's post regarding a workaround with IM 10, but that doesn't seem to work with IM 2010.
I've tested on two machines and get the same results on both.
http://www.archivum.info/microsoft.public.greatplains/2008-04/01335/Re:_boosting_connectivity_on_GP_workstations
It seems that IM 2010 crashes using the newer ACE XLSX driver.
I've tried saving the file as an Excel 97-2003 xls file, but that results in the same crash if the same XLS / XLSX ACE driver (v14.00) is used.
I've also tried using the older XLS ODBC driver (v6.01). Although IM doesn' t immediately crash, it gives me a "No tables found" message.
Problem signature:
Problem Event Name: BEX
Application Name: Microsoft.Dynamics.GP.IntegrationManager.exe
Application Version: 11.0.1767.0
Application Timestamp: 4da87806
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.6161
Fault Module Timestamp: 4dace5b9
Exception Offset: 0003523b
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.1.7601.2.1.0.272.7
Locale ID: 1033
Additional Information 1: 3896
Additional Information 2: 389661daf8315bf792ef7b6babdc073b
Additional Information 3: 7a0d
Additional Information 4: 7a0d39aa8166f1e6d12d664ebea405b3
*This post is locked for comments
Update: Well, it has been several years since I setup an Excel data source with Integration Manager.
I forgot to define the Data Range in the XLSX file.
Once I added the Data Range, the ACE XLSX driver worked fine and IM didn't crash.
And that also explains the "No tables found" message with the older ODBC XLS driver.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156