‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine error

If you are using a 64-bit OS, please follow the steps below:

1. Install Microsoft Access Database Engine 2010 Redistributable from here.
2. Restart (just in case) your machine and see if that works for you.
3. If not, you also need to install 2007 Office System Driver: Data Connectivity Components from here.
4. Restart your machine and the error should go away.