GoAnywhere Forum

I am trying to import an Excel Spreadsheet to the AS/400 using the Read Excel and SQL Insert functions. When I encounter a cell that should contain numeric data but instead is blank, the process fails. Is there a way to have an empty cell replaced with a zero for numeric fields?

In either the Data element or the individual column elements in the read Excel task, select the system.empty.string variable for the Null Indicator field. Then, when writing from the dataset, specify 0 for the Null Substitute value.