未在本地计算机上注册Mirosoft.Jet.OldDb.4.0提供程序...

OleDbConnection _oledb = new OleDbConnection("Provider=Microsoft.Jet.OldDb.4.0;Data Source='"+this.textBox1.Text+"';extended properties=Excel 5.0");
            _oledb.Open();
        MessageBox.Show("");
我要将Excel数据导入到Sql中 要给excel创建连接   运行后出现错误:未在本地计算机上注册"Microsoft.Jet.OldDb.4.0"提供程序.
这是怎么搞的??

搜索更多相关主题的帖子: Jet Mirosoft OldDb 计算机 Microsoft

top

2.操作实例
string FullPath=FileImport.PostedFile.FileName;
            try
            {
                OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+FullPath+";Extended Properties=Excel 8.0;");
                myConn.Open();
                OleDbDataAdapter thisAdapter= new OleDbDataAdapter("SELECT * FROM [zw_product$]",myConn);
                OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
                DataSet thisDataSet=new DataSet();
                thisAdapter.Fill(thisDataSet,"ExcelInfo");
                LabelStatus.Text=thisDataSet.Tables["ExcelInfo"].Rows[1][1].ToString();
                myConn.Close();    
            }
            catch(OleDbException ex)
            {
                LabelStatus.Text=ex.Message;
            }
算你走运