string Path = "C:\\mdb.xls";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO [sheet1$] (A$) VALUES('" + s + "')";
cmd.ExecuteNonQuery();说这个错误
cmd.CommandText = "INSERT INTO [sheet1$] (A$) VALUES('" + s + "')";
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO [sheet1$] (A$) VALUES('" + s + "')";
cmd.ExecuteNonQuery();说这个错误
cmd.CommandText = "INSERT INTO [sheet1$] (A$) VALUES('" + s + "')";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货