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


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

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.