title: How do I specify multiple header rows when using SQL to query an Excel spreadsheet?
body: <p>I'm trying to query an Excel spreadsheet using SQL. The problem I'm facing is that one of the sheets I would like to query has 2 header rows. This is a sheet from a report I receive weekly from an external source and have an archive going back 3 years, so simply removing the extra row isn't an option.</p>
  
  <p>Is there any way to tell Excel(/SQL) to treat both rows as headers (or to ignore the first row altogether - the important header information is in the second row)?</p>
  
  <p>here is my connection string if it makes any difference:</p>
  
  <pre><code>"Provider=Microsoft.Jet.OLEDB.4.0;" &amp; _
      "Data Source=" &amp; fileName &amp; ";" &amp; _
          "Extended Properties=""Excel 8.0;HDR=Yes;IMEX=0"";"
  </code></pre>
  
  <p>Thanks,</p>
  
  <p>Gary</p>