We are trying to import from an xls file and one of the columns have values that are numbers but some are text/string, like "B1234".
When we use ODBC Importer the Result Preview only shows the data when it is mixed ("B1234"), where is should be a number the cells are blank.
If we have a column with only numbers it shows up correctly.
What should I do to get the import to work?
Using PL/SQL Developer 7.1.5.1398
When we use ODBC Importer the Result Preview only shows the data when it is mixed ("B1234"), where is should be a number the cells are blank.
If we have a column with only numbers it shows up correctly.
What should I do to get the import to work?
Using PL/SQL Developer 7.1.5.1398
