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

a_houston

User avatar
Verified User
Posts: 4
Joined: Fri Jun 05, 2009 11:38 am
Location: USA

Post by a_houston » Mon Aug 31, 2009 10:01 am
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

Support Specialist
Posts: 66
Joined: Thu Mar 05, 2009 3:49 pm

Post by Support_Duane » Fri Sep 25, 2009 3:23 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