Null values when uploading
How can null values be converted to BLANKS, when uploading an Excel spreadsheet to the AS/400 with Client Access.
Software/Hardware used:
Software/Hardware used:
ASKED:
August 8, 2008 5:18 PM
UPDATED:
August 12, 2008 8:08 PM
Answer Wiki:
Off hand, I am not sure whether Client Access data transfer can do that or not. Are you committed to using that method? If not, saving the Excel spreadsheet to a .CSV file and then importing that .CSV file to a physical file on the system formerly known as AS/400 can also be done via the CPYFRMIMPF command (or CPYFRMSTMF). There is a parameter in CPYFRMIMPF that will replace null values with the field default.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
