Operation must use an updateable query
using (OleDbConnection objConn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FilePath1 + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1;';")) { objConn.Open(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = objConn; cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE [Sheet1$] SET [F6]='5' where [F2]='2992269'"; cmd.ExecuteNonQuery(); }
IMEX=1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)