If a user is importing data to a table that has a column with a NUMBER datatype and on the Excel spreadsheet, they are using for the import, one of the values for the NUMBER column is a space, they get prompted with a message saying there is an invalid value trying to be imported. In this case, instead of being prompted can Toad automatically remove the space from the value and just enter a NULL value?
WORKAROUND:
Manually remove the space from the Excel shet.
STATUS:
Waiting for enhancment to be implemented in a future version of Toad for Oracle.
