.net使用OLEDB操作Excel
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties='Excel 8.0;HDR=No;IMEX=0'";
OleDbConnection conn = new OleDbConnection(strConn);
//打开连接
conn.Open();
System.Data.OleDb.OleDbCommand cmd = new OleDbCommand();
cmd.Connection = conn;
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
cmd.CommandText = "INSERT INTO [sheet1$] (F1,F2) VALUES('1','2')";
//执行Sql
cmd.ExecuteNonQuery();
}
//关闭连接
conn.Close();
他报的错误时说:INSERT INTO 语句包含下列未知的字段名: 'F2'。确定键入的名称是正确的
这个怎么解决呢?大神