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

Published on Author bloggerone

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 Engine)

http://www.microsoft.com/download/en/details.aspx?id=13255

Comments

comments