The spreadsheets had few fields so not much of a pain and I did not look for a reason why this is happening. I am now working with a spreadsheet that has 38 columns to be transferred and changing from UNICODE to CHARACTER has become a pain.
Fifteen minutes of Google search and problem solved. With Google the answers are always only a few keystrokes away!
The command did return something about failed but it did just what was needed. Not sure what the failed message is for.
When the world says, "Give up,"
Hope whispers, "Try it one more time."
Have your best day!