Inporting an Excel Spreadsheet
Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts
Page 1 of 1
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?
Last edited by a_houston on Fri Nov 20, 2009 10:28 am, edited 1 time in total.
- Support Specialist
- Posts: 66
- Joined: Thu Mar 05, 2009 3:49 pm
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.
2 posts
Page 1 of 1