Why just get NULL return from excel oledb
-
Hi everyone, I use the OLE connection to read data from excel file; OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + "; Jet OLEDB:Engine Type=5;" + "Extended Properties=\"Excel 8.0;\""); OleDbDataAdapter SheetAdapter = new OleDbDataAdapter("select * from [" + strSheetName + "]", conn); But when using the method to read the excel data like this: 111111111 2222(ds)/1232(jjj) It just return NULL to the dataset row. I really don't know why ? Can you help me please? Thanks in advance.
-
Hi everyone, I use the OLE connection to read data from excel file; OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + "; Jet OLEDB:Engine Type=5;" + "Extended Properties=\"Excel 8.0;\""); OleDbDataAdapter SheetAdapter = new OleDbDataAdapter("select * from [" + strSheetName + "]", conn); But when using the method to read the excel data like this: 111111111 2222(ds)/1232(jjj) It just return NULL to the dataset row. I really don't know why ? Can you help me please? Thanks in advance.
Clearify question: the 11111111 is returned well, but can't get the next row - 2222(ds)/1232(jjj):(