i read an excel file onto my VB.net project using oleDB. The Excel file has text column, which most of the data is numeric but some cells are string. The system consider the column as Double and it does not read the cells with string value (non-nomeric).
Task: Need code to read the column as String data type so I get all the cells.
======================================
currently the basic code to create the dataset is;
prm_ConnectionString = "Provider=Microsoft.Jet.OleDb.4.0;data source=##FILE##;Extended Properties=Excel 8.0;"
prm_DATAatapter = New [login to view URL](strSQL, prm_ConnectionString)
[login to view URL] = [login to view URL]
[login to view URL](obj_DataSet, sName)
==============================