The error "ACE.OLEDB.12.0 Provider Not Registered on local machine" is common when using the "Execute SQL Statement" Action.



Resolution


Double check that you have properly installed the corresponding ODBC drivers:

https://www.microsoft.com/en-us/download/details.aspx?id=5793 

https://www.microsoft.com/en-us/download/details.aspx?id=13255 

https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=23734


If everything is set up correctly, check your Microsoft Office architecture (64 or 32 bit).


In case you are attempting to use ODBC on a 64bit machine whilst your Microsoft Office version is 32 bit 

  • Download this file here
  • Do export the contents of the zip file to your desktop.
  • Exit WinAutomation from the system tray by right clicking on the WinAutomation action and selecting "Exit".
  • Right click on the executable file called "ForceDotnet32bitOnExeFiles.exe" and select "Run as Administrator" 

This will handle all the configuration changes needed to be done so that you can combine a mix of 32 and 64 bit Office and Windows.