'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 · 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.