IBM i transfer Convert UNICODE to CHAR

For the past couple of years I have noticed when transferring a file to IBM i from Excel the default field type is UNICODE. That caused issues with data after transfer so I have been manually changing them during file transfer definition process to CHARACTER.

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!

Microsoft Excel Data Transfer Add-Ins: Convert UNICODE to CHAR

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."
~Author Unknown


Have your best day!

~Richard