title: Excel Oledb Update Query - Updating header row in Excel 2016
body: <p>Trying to update the rows in Excel using Oledb, but update query updates Header row in Excel 2016.</p>
  <p><strong>It works perfectly fine in Excel 2010</strong> or earlier, just wondering what is required in Excel 2016? To have this worked.</p>
  <p>Excel sheet is as below,</p>
  <p><a href="https://i.stack.imgur.com/5WeZa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5WeZa.png" alt="enter image description here" /></a></p>
  <p>The connection string used for Connect is as below,</p>
  <blockquote>
  <p><code>&quot;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&quot; + filePath + &quot;;Extended Properties=\&quot;Excel 8.0;\&quot;&quot;;</code></p>
  </blockquote>
  <p>Update query used as below,</p>
  <pre><code>Update [Sheet1$A2:C] set [Head 1] = 'ABC'  Where [Rno]=1
  </code></pre>
  <p>The output of this query in Excel 2016.</p>
  <p><a href="https://i.stack.imgur.com/kKDcH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kKDcH.png" alt="enter image description here" /></a></p>
  <p>Any hints will be greatly appreciated.</p>