If you ever run into this error when trying to export data from UPS WorldShip:
ODBC ERROR: State = 22005 Error = [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification
…here’s the solution. The "defout.mdb" file that exists on your source installation is corrupt. I’m assuming this, as what proceeds seems to solve the issue. In order to get a clean copy of this file, you need to create a address book on a new installation of UPS WorldShip (possibly on the machine you will be importing to) and export that address book on there. Then take the defout.mdb file from the new system, copy it to the old system, and retry the export on the old system. This time it should complete without failure.