Excel导入数据库的 OleDb 连接串的格式,发生错误:找不到可安装的 ISAM。
FILEname = "EXCEL" + DateTime.Now.ToString("yyyyMMddHHmmssfff") + up[up.Length - 1];
File1.PostedFile.SaveAs(Server.MapPath(@"/exceltest/exceldaoru/") + FILEname);
string FilePath = Server.MapPath(@"/exceltest/exceldaoru/") + FILEname;
string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(@"/exceltest/exceldaoru/") + FILEname + ";Extended Properties='Excel 12.0;IMEX=0'";
System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strCon);
string strCom = "SELECT * FROM [Sheet1$]";
Conn.Open();
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strCom, Conn);
DataSet ds = new DataSet();
myCommand.Fill(ds, "[Sheet1$]");
Conn.Close();
myCommand.Dispose();
string ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString();
conn = new SqlConnection(ConnectionString);
conn.Open();
int insertcount = 0;//记录插入成功条数