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.
Post a reply

Inporting an Excel Spreadsheet

Postby a_houston » Mon Aug 31, 2009 9: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 9:28 am, edited 1 time in total.
User avatar
a_houston
Verified User
 
Posts: 4
Joined: Fri Jun 05, 2009 10:38 am
Location: USA
Top

Re: Inporting an Excel Spreadsheet

Postby Support_Duane » Fri Sep 25, 2009 2: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.
Support_Duane
Support Specialist
 
Posts: 66
Joined: Thu Mar 05, 2009 2:49 pm
Top
Post a reply

Return to Community Forum

Who is online

Users browsing this forum: No registered users and 0 guests

cron