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.