title: Operation must use an updateable query when updating excel sheet
body: <p>I am getting this error when trying to update excel sheet :</p>
  
  <pre><code>Server Error in '/ReadExcelData_Csharp' Application.
  Operation must use an updateable query. 
  </code></pre>
  
  <p>and here is  the code that i am using :</p>
  
  <pre><code>  querys = "UPDATE [Sheet1$] "+"SET [Number]=" +s.Trim()+ " WHERE [Number]=" + s2.Trim() ;
    objcmc = new OleDbCommand(querys, conn);
    objcmc.ExecuteNonQuery();
  </code></pre>
  
  <p>any help will be appreciated . </p>
  
  <p>and here is the connection i used :</p>
  
  <pre><code>if (strFileType.Trim() == ".xls")
              {
                  connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
              }
              else if (strFileType.Trim() == ".xlsx")
              {
                  connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + strNewPath + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
              }
  </code></pre>