title: OleDB read excel but return wrong number format
body: <p>I need a help at reading excel with mixed type in one column.
  i have a column with value like this</p>
  
  <pre><code>080810235707 -&gt; text type
  614810003481 -&gt; text type
  150130301951 -&gt; text type
  612130001653 -&gt; text type
  612130000354 -&gt; text type
  612130001926 -&gt; text type
  612810001877 -&gt; text type
  81130518669 -&gt; numeric type
  81130518614 -&gt; numeric type
  612130001686 -&gt; text type
  612130001119 -&gt; text type
  </code></pre>
  
  <p>and this is my connection string:</p>
  
  <pre><code>string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + _view.FileName + ";Extended Properties = 'Excel 8.0; HDR=Yes; IMEX=1; ImportMixedTypes=Text; TypeGuessRows=0' ");
  </code></pre>
  
  <p>and the result is wrong when OleDB read it:</p>
  
  <pre><code>080810235707
  614810003481
  150130301951
  612130001653
  612130000354
  612130001926
  612810001877
  8.11305e+010 -&gt; the numeric become like this
  8.11305e+010 -&gt; the numeric become like this
  612130001686
  612130001119
  </code></pre>
  
  <p>How to set OleDB so it read all in text type not, numeric?
  Thank you</p>
  
  <hr>
  
  <p>EDIT</p>
  
  <p>This is my code to read excel, how to implement the code to convert column type:</p>
  
  <pre><code>DataSet ds = new DataSet();
  string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + _view.FileName + ";Extended Properties = 'Excel 8.0; HDR=Yes; IMEX=1; ImportMixedTypes=Text; TypeGuessRows=0' ");
  
  
   OleDbConnection conn = new OleDbConnection(connectionString);
   conn.Open();
   dtSchemaTemp = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
   conn.Close();
  
  strSheetTemp = dtSchemaTemp.Rows[i]["TABLE_NAME"].ToString();
  OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM [" + strSheetTemp + "]", connectionString);
  
  adapter.Fill(ds, "ExcelData");
  DataTable dt = ds.Tables["ExcelData"];
  </code></pre>