title: Import Excel to DataTable string's are empty
body: <p>To import excel to datatable, I am using the simple code:</p>
  
  <pre><code>string connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0; data source={0}; Extended Properties=Excel 12.0;", physicalFolder + FileUpload1.FileName);
  OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString);
  DataSet ds = new DataSet();
  </code></pre>
  
  <p>When in one of the rows of excel, if my row looks like below</p>
  
  <p><img src="https://i.stack.imgur.com/a74Yf.jpg" alt="enter image description here"></p>
  
  <p>strings are ommited and my data set looks like this</p>
  
  <p><img src="https://i.stack.imgur.com/0HlWu.jpg" alt="enter image description here"></p>
  
  <p>However if I add some strings and if my upload looks like this: </p>
  
  <p><img src="https://i.stack.imgur.com/HsouJ.jpg" alt="enter image description here"></p>
  
  <p>Then my dataset looks like it does not omit the strings: </p>
  
  <p><img src="https://i.stack.imgur.com/cvKRV.jpg" alt="enter image description here"></p>