title: Excel update query putting all data in row 1
body: <p>I'm using an oledbconnection to connect to an excel spreadsheet</p>
  
  <p>Connection string:</p>
  
  <pre><code>string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" +
                               Request.PhysicalApplicationPath + "tmp\\" + Session["Id"] + ".xlsx;" + "Extended Properties=\"Excel 8.0;HDR=NO;\"";
  </code></pre>
  
  <p>Update query:</p>
  
  <pre><code>cmdUpdate = new OleDbCommand("UPDATE [Contributions$B6:B6] SET F1 = 'value'", excelConn);
  </code></pre>
  
  <p>However, the data is being set in cell B1, not B6.  All other queries are also adding the data in row 1, but the correct column...any ideas?</p>