得到无法找到已安装的ISAM的错误 [英] getting error that cannot find installed ISAM

问题描述

strConnection.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["a"].ToString();
//file upload path
//string path = fileupload1.PostedFile.FileName;

fileupload1.SaveAs(Server.MapPath("~/excel/" + fileupload1.FileName));
string a = "~/excel/" + fileupload1.FileName;
//Create connection string to Excel work book
string excelConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source='a';Extended Properties=Excel 8.0 Xml;HDR=YES;";


//Create Connection to Excel work book
OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);

//Create OleDbCommand to fetch data from Excel
OleDbCommand cmd = new OleDbCommand("Select [ID],[Name],[Designation] from [Sheet1$]", excelConnection);
excelConnection.Open();
OleDbDataReader dReader;
dReader = cmd.ExecuteReader();
SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection);

//Give your Destination table name
sqlBulk.DestinationTableName = "Excel_table";
sqlBulk.WriteToServer(dReader);
excelConnection.Close();

[edit]已添加代码块 - OriginalGriff [/ edit]

[edit]Code block added - OriginalGriff[/edit]

推荐答案

，excelConnection）;
excelConnection.Open（）;
OleDbDataReader dReader;
dReader = cmd.ExecuteReader（）;
SqlBulkCopy sqlBulk = new SqlBulkCopy（strConnection）;

// 提供目标表名称
sqlBulk.DestinationTableName = Excel_table;
sqlBulk.WriteToServer（dReader）;
excelConnection.Close（）;

", excelConnection); excelConnection.Open(); OleDbDataReader dReader; dReader = cmd.ExecuteReader(); SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection); //Give your Destination table name sqlBulk.DestinationTableName = "Excel_table"; sqlBulk.WriteToServer(dReader); excelConnection.Close();

[edit]已添加代码块 - OriginalGriff [/ edit]

[edit]Code block added - OriginalGriff[/edit]

这篇关于得到无法找到已安装的ISAM的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！