'Microsoft.ace.oledb.12.0'提供程序未在本地计算机上注册。 [英] 'Microsoft.ace.oledb.12.0' provider is not registered on the local machine.

问题描述

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.

OS：WINDOW 10和Window 2007年

VS 2010

Sql Server 2008R2



我的尝试：

OS: WINDOW 10 and Window 2007
V.S 2010
Sql Server 2008R2

What I have tried:

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();
}
}

推荐答案

;
con.Close（）;
}
}

"; con.Close(); } }

阅读： c＃ - 'Microsoft.ACE.OLEDB.12.0'提供程序未在本地计算机上注册 - Stack Overflow [ ^ ]

这篇关于'Microsoft.ace.oledb.12.0'提供程序未在本地计算机上注册。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！