oledb - DataTable is sorted after selecting from Excel -


Dataset is sorted when I select a record from excelcate. I want to record the same sequence as excelsheet, why data format has been sorted.

OleDbCommand objCommand = new OleDbCommand ("Select specific * to [" + strSheet + "]", objXConn);

OleDbDataAdapter objAdapter = New OleDbDataAdapter (objCommand);

objAdapter.Fill (dtEx);

This first column was taking the datatype as numeric. I added IMEX = 1 in extended properties, since the column is considered as a string, the data is no longer sorted.

Thanks


Comments