Windows : Microsoft.ACE.OLEDB provider is not registered on the local machine

By | February 4, 2012

Trying to import Excel datasheet into MSSQL database using .NET application and get this error?

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

This indicate you are required to install the two following component on the server : Access Database Engine as well as Excel.

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