title: Using JET OLEDB Provider, How to query headerless text file using a WHERE clause?
body: <p>This may be a silly question, but I can't figure out the correct syntax or if this is even possible.</p>
  
  <p>I have a text file that I am querying using the Microsoft.Jet.OLEDB.4.0 Provider. The text file consists is a Headerless CSV that looks somewhat like this:</p>
  
  <pre><code>4/11/2012 9:20:19 AM,USERID,GROUPNAME
  4/12/2012 9:20:19 AM,USERID2,GROUPNAME3
  4/13/2012 10:45:15 AM,USERID3,GROUPNAME2
  </code></pre>
  
  <p>I can query the entire text file with a <code>SELECT * FROM...</code> but I'd like to be able to query it on one of the columns. <code>SELECT * FROM myTextFile.txt WHERE column2='USERID'</code></p>
  
  <p>My problem is, how can I specify the column when there is no header? Is there any way to specify the second column? Something like <code>WHERE {1}='USERID'</code></p>
  
  <p>Thanks for the responses in advance!</p>