title: Data is missing while reading excel file using OLEDB
body: <p>I am using OLEDB to read excel file into datatable. But the problem is, some values are missing(Empty). In my excel sheet one column datatype is General, it has mixed values like string and integers. Most of the cell values are integers. Why OLEDB is skipping string values.</p>
  
  <pre><code>OleDbConnection connection = new OleDbConnection();
  
  connection.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + "; Extended Properties=\"Excel 12.0;IMEX=1\";";
  OleDbCommand myAccessCommand = new OleDbCommand();
  
  myAccessCommand.CommandText = "Select * from [" + sheetName + "]";
  
  OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(myAccessCommand);
  
  myDataAdapter.Fill(myDataSet);
  </code></pre>