title: Data truncating after 255 characters when inserting into dataset from Excel but no issue when populating DataTable
body: <p>I am trying to insert the data from Excel file to dataset using ADO.NET. Below is the procedure adopted</p>
  
  <ol>
  <li>First all excel data are loaded into dataset using </li>
  </ol>
  
  <blockquote>
    <p>connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=mydb.xlsx;Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";</p>
  </blockquote>
  
  <ol>
  <li>when populating dataset it inserts only 255 characters. (I couldn't find where it is truncating). In our source code there is no code for truncating. But when same connection is used to fill a datatable no such problem occurs. </li>
  </ol>
  
  <p>Please help me to over come this problem</p>
  
  <p>Thanks in advance</p>