Reading Excel by OLEDB reads strings as DBNull
<p>I am reading Excel file using OLEDB in Csharp i have shown the sample excel data what i have</p>

<pre><code>F1    F2    F3    F4
India 23    44    4
China 4     8     Month 6
USA   45    Neg   4
</code></pre>

<p>When i read this data and check in my DataTable i get Null values for "Month 6" and "Neg"
where as i can be able get the F1 column correctly... my connection string is as shown </p>

<p>Provider=Microsoft.ACE.OLEDB.12.0;Data Source=[XLSource];Extended Properties=Excel 12.0;</p>

<pre><code>OleDbDataReader dr;
OleDbConnection conExcel = new OleDbConnection();
conExcel.ConnectionString = ConnectionString
conExcel.Open();
OleDbCommand cmdExcel = new OleDbCommand();
cmdExcel.Connection = conExcel;
cmdExcel.CommandText = "SELECT * FROM Sheet1$";
dr = cmdExcel.ExecuteReader();
DataTable dtExcel = new DataTable();
dtExcel.Load(dr);
</code></pre>
