'Microsoft.ACE.OLEDB.12.0' provider is not registered

Question

'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Rajeev Punhani · Answer

Hi Viv,

Please see the below link.

https://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine?forum=vstsdb

viv verma · Answer

when i am going to upload control & upload excel files then click btnUpload use Oledb connection, when do the Open connection then this message are shown.

using (OleDbConnection con = new OleDbConnection(conString))

{

using (OleDbCommand cmd = new OleDbCommand())

{

cmd.Connection = con; //here msg popup shown

con.Open();

dtTabs = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

//sheetName = dt.Rows[0]["Table_Name"].ToString();

//sheetName = "Insureds$";

con.Close();

}

OS: WINDOW 10 and Window 2007
VS2010

Salman Beg · Answer

Hi. You need to install AccessDatabaseEngine and please follow this link to install it " http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 " thanks.