title: Reading CSV file with OLEDB ignores first line even with HDR=No in Connection String
body: <p>We're converting a Classic ASP site to an ASP.NET site.  One function was to upload a 'template' of data in CSV format for importing into the database.  There were several different record types in there (the first field always indentifies the type of data).</p>
  
  <p>The task was to get the CSV into a DataTable so it could be validated (new project is to have MUCH better validation rules)</p>
  
  <p>The code seemed pretty straightforward - watered down (taking out comments, Try/Catch, etc) it is as follows:</p>
  
  <pre><code>    Dim da As New System.Data.OleDb.OleDbDataAdapter
      Dim cn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp; strDirectory &amp; ";" &amp; "Extended Properties=""Text;HDR=No;FMT=Delimited;""")
      Dim cd As New System.Data.OleDb.OleDbCommand("SELECT * FROM " &amp; strCSVFilename, cn)
      cn.Open()
      da.SelectCommand = cd
      da.Fill(dtData)
  </code></pre>
  
  <p>The DataTable (dtData) is populated, but only starting with the second line of the CSV file DESPITE the fact that "HDR=No" is in the connection string.</p>
  
  <p>What am I missing here?</p>