System.Data.OleDb.OleDbException: Syntax error in UPDATE statement

Question

I have an excel file with 2 sheets and want update some values in 'Data' sheet. I use the next simple commands:

var myCommand = new OleDbCommand();
var sql = "Update [Sheet2$] set Status = 'New_value' WHERE Building = 12";
var myConnection = new OleDbConnection(connectionString);
myCommand.CommandText = sql;
myCommand.ExecuteNonQuery();

I get error:

System.Data.OleDb.OleDbException : Syntax error in UPDATE statement

I have also tried this:

var sql = "Update [Sheet2$] set Status = 'New_value' WHERE Building = '12'";

but with no success. What is wrong here?

Hi, thanks for suggestion. I changed it to 'HDR=YES' and used second answer ([Status]) and it worked. — SimonD
– SimonD, Commented Oct 10, 2012 at 9:05
But it is necessary to put the square brackets after the HDR=YES? — Steve
– Steve, Commented Oct 10, 2012 at 9:07

John Woo · Accepted Answer · 2012-10-10 07:52:37Z

3

escape the column status

var sql = "Update [Sheet2$] set [Status] = 'New_value' WHERE Building = 12";

answered Oct 10, 2012 at 7:52

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

System.Data.OleDb.OleDbException: Syntax error in UPDATE statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related