Problem While Reading Values From Excel Into Dataset .

Question

Hi,

i am reading values from an excel file into a dataset using asp.net and the connection is oledb connection.
connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileLocation + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=1\"";

At times there exists values in the cell but are not being read into the dataset. the values in the dataset show up as null/dbnull.

plz let me know if you can help me in figuring this out.



thanks in advance.