1
Answer

Problem While Reading Values From Excel Into Dataset .

sirisha chowdar muppalaneni

sirisha chowdar muppalaneni
9y
381
1
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.
Answers (1)
Next Recommended Forum