: ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb), C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEODBC.DLL)

excel

#1

Hi every one,

I am working on Excel Automation while doing that I used SQL queries to get data from excel sheet through execute query activity below error came , please any one reply for this to resolve.
" : ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb), C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEODBC.DLL)."

thanks in advance


#2

I would guess you don’t have the right driver. Try this:

1.) Go to your Data Source Adminstrator ( Run c:\Windows\SysWOW64\odbcad32.exe).
2.) Click on System DSN tab.
3.) Click Add.
4.) Select the Microsoft Excel Driver and add it.

Good luck,
Matt