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

Postby 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.
User avatar
a_houston
Verified User
 
Posts: 4
Joined: Fri Jun 05, 2009 11:38 am
Location: USA

Re: Inporting an Excel Spreadsheet

Postby 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.
Support_Duane
Support Specialist
 
Posts: 65
Joined: Thu Mar 05, 2009 3:49 pm


Return to Community Forum

Who is online

Users browsing this forum: Yahoo [Bot] and 2 guests