title: Using OleDBDataReader to read Excel not retrieving all of a header column cells content
body: <p>I have an Excel sheet that I am using to populate data in a Database. It seems as though there is only a certain number of characters that the OleDBDataReader actually reads in from a column heading before truncating the rest. </p>
  
  <p>Is there a way around this?</p>
  
  <p>How I am retrieving the column headings:</p>
  
  <pre><code>OleDbCommand oleDbCommand = new OleDbCommand("select * from [sheet1$]",
  OleDbConnection);
  OleDbDataReader reader = oleDbCommand.ExecuteReader();
  DataTable dataTable = new DataTable();
  dataTable.Load(reader);
  
  foreach (DataColumn column in dataTable.Columns)
  {
  string columnName = column.ColumnName;
  }
  </code></pre>
  
  <p>Expected result: Targeted programs to address the welfare needs of students. E.g <code>breakfast clubs</code></p>
  
  <p>Actual Result: Targeted programs to address the welfare needs of students. E.g <code>br</code></p>
  
  <p>I have also tried using the <code>reader.GetName(i)</code> method to retrieve the information with the same result.</p>