C#操作excel问题
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + filepath + ";" + "Extended Properties=Excel 8.0";
System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(strConn);
OleDbConnection conn = new OleDbConnection(strConn);
OleDbCommand cmd = new OleDbCommand("alter table [第1页$] add 户经理1 text", conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
想用alter增加一列报:“无效的操作。”
请各位大大帮忙解决,谢谢!