ms jet rounding double values

Question

User189827543 posted

Hello,

I am using this code to import data from excel into my application:

    public DataTable Import(string fileName)
    {
        try
        {
            string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + "; Extended Properties='Excel 8.0; IMEX=1; HDR=YES'";
            System.Data.OleDb.OleDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM [DATA$]", connectionString);
            DataSet dataSet = new DataSet();
            dataAdapter.Fill(dataSet, "ExcelInfo");
            DataTable dataTable = dataSet.Tables["ExcelInfo"];
            return dataTable;
        }
        catch(Exception e)
        {
            return null;
        }
    }

When I access the values from the data table, I notice that it contains the formatted values for my cells and not actual values.For certain float/double cells - I am losing precision. Values are being rounded. Any ideas on how I can get around this? Do I have to rewrite this import code to use something other than MS Jet?