Oracle SQL Developer Source columns are mapped to a previously mapped target column

Hello expert,

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'
It returns
'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?
 
Thanks

Allen in Dallas
Allen PittsBusiness analystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Gerwin Jansen, EE MVETopic Advisor Commented:
Hi Allen,

I don't have access to SQL Developer at the moment but I remember that the import wizard will let you map columns from input to columns in the database. I think it's step 4 or 5 in the wizard.
0
Mark GeerlingsDatabase AdministratorCommented:
Is there any possibility that something changed on the target side, like if these columns were dropped from the table, or renamed after an earlier import?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Allen PittsBusiness analystAuthor Commented:
Thanks Mark and Gerwin, I'm a little red-faced, but someone changed the column name on the Excel file from 'CRM_REQUESTER_ID' to 'CRM_REQUESTOR_ID'. Lined up the names and it worked.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.