关于oledb操作excel

Candbasic 2009-03-19 07:53:33

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=d:\\1.xls;Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";";
conn.Open();
OleDbCommand olecommand = new OleDbCommand("update [st$] set number='333' where name='1'", conn);
olecommand.ExecuteNonQuery();
conn.Close();

用oledb 更新excel时，为什么出现update语句有语法错误？

...全文

146 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

rx78gp01 2009-03-20

打赏
举报

把$符号去掉

sxmonsy 2009-03-20

打赏
举报

update [sheet1] set number='333' where name='1'

liujiayu10 2009-03-20

打赏
举报

public DataSet ExcelDataSource(string filepath, string sheetname)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath + ";Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
OleDbDataAdapter oada = new OleDbDataAdapter("select * from [" + sheetname + "$]", strConn);
DataSet ds = new DataSet();
oada.Fill(ds);
return ds;
}

Candbasic 2009-03-20

打赏
举报

再顶，，，，

EveryCase 2009-03-20

打赏
举报

顶~~~~~~~~~~~~~~

Candbasic 2009-03-20

打赏
举报

还是不行，，，

oranrry 2009-03-20

打赏
举报

把Update语句的单引号去掉试一试
update [st$] set number=333 where name='1'

update [st$] set number='333' where name=1

update [st$] set number=333 where name=1

三种情况都试一试

Candbasic 2009-03-20