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.
Loading
Nanhe SiddiquePosted May 25, 2015, 1:38 AM