title: updating data in EXCEL using ado.net , how to refer to columns in sql statement?
body: <p>I am connecting to the excel file using ADO.NET OLeDB drivers.
  In the connection string I have HDR=NO ( which means my excel file does not have header)</p>
  
  <p>I want to run update statement and refer to column as they are in excel file.
  The below sql query throws the following error : <strong>No value given for one or more required parameters.</strong></p>
  
  <pre><code>update [fact$] set AC='test123' where DO='xxxyyy'
  </code></pre>
  
  <p>Here 'AC' and 'DO' are the respective columns on excel sheet 'fact'.</p>