Windows : Microsoft.ACE.OLEDB provider is not registered on the local machine
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