title: Importing Excel data into C# without first row becoming column names?
body: <p>I am trying to import data from excel into a datatable using c#. Here is the code I use to do so...</p>
  
  <pre><code>string ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
                      "Data Source=" + fileName + "; Jet OLEDB:Engine Type=5;" +
                      "Extended Properties=\"Excel 8.0;HRD=No;IMEX=1;\"";
  OleDbDataAdapter SheetAdapter = new OleDbDataAdapter("select * from ["Sheet1"]", conn);
  System.Data.DataTable excelData = new System.Data.DataTable();
  SheetAdapter.Fill(excelData);
  excelData.TableName = "excelData";
  
  foreach (DataRow row in excelData.Rows)
  {
     ProcessDataRow(row);
  }
  </code></pre>
  
  <p>When I look at the datatable while debugging the first row of data has become the tables column names. I don't understand why this is happening when I put HDR=No into the connection string. Is there a way to force the DataTable to not take the first row as column names?</p>