the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine

Published on

Situations: When you try connecting Access database in visual studio. importing excel file into SQL Server OS: Windows 2008 R2 Error: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data) Solution; (If you have Office installed in the system you may not come across this) Install the following from the link given below. (Access Database … Continue reading the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine