Importing data from Excel file into a truncated table in Oracle database (not sure how to tell which version of Oracle but the Oracle SQL Developer is Version 3.1.7). In the Data Import Wizard, Step 5 of 5, the Verify button is clicked and all the verifications are marked 'Success'
except the one marked:
'Verifying if source columns have target columns mapped'
'FAILED Source columns CRM_REQUESTOR_ID, CRM_REQUESTOR_NAME are mapped to a previously mapped target column'
Some research says that when this happens in a CVS file the semicolon at the end of a line indicates to SQL Developer that there is more data and it looks for more and fails.
But this import is using an Excel (.XLS).
I tried changing the two fields that are failing to data type 'Text' n Excel but this did not help.
What can be changed to get the columns to map properly?
Allen in Dallas