Hi,
I am trying to update a excel sheet creating an OleDB connection.
I am able to retrieve records but I am an unable to update any records.
This is what my query looks like:
Update [Sheet1$] SET F14='HP935' WHERE Manufacturer='Proliant DL585 Server' AND Product Description='Hewlett-Packard' AND ProductNumber='DL585'
And this is the error i get:
{System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'Manufacturer='Proliant DL585 Server' AND Product Description='Hewlett-Packard' AND ProductNumber='DL585''.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
Any help is appreciated.
Thanks
I just figured it out also. :D Appreciate all your help bob.