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.
Last Wiki Answer Submitted: August 12, 2008 8:08 pm by Cwc4,275 pts.