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.
Inporting an Excel Spreadsheet
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_Duane Offline
- Support Specialist
- Posts: 66
- Joined: Thu Mar 05, 2009 3:49 pm
Re: Inporting an Excel Spreadsheet
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.