title: OLEDB query on Excel without headers: How do I specify Columns?
body: <p>I need to be able to handle Excel files versions 97 - 2010 and also those with and without header info.</p>
  
  <p>Don't need help with connection strings : that works.</p>
  
  <p>What I do need help with is querying worksheets that do not have header information i.e. no descriptor of a column's data in the first row. How do I refer to these columns in the OLEDB query?
  I've tried the following</p>
  
  <pre><code>"Select [Sheet2$A] from [Sheet2$]"  //selecting Column A
  "Select [Sheet2$A$] from [Sheet2$]"  //selecting Column A
  </code></pre>