RE: Upload excel sheet to DB2 file on AS400

[Dennis <iseries@xxxxxxxxxxxx>]

Have a look at http://www.scottklement.com/poi/

Good stuff!
++
Dennis
++
 "I would rather men should ask why no statue has been erected in my honor, than why one has."
     -- Marcus Cato (2nd century BC)
"It is better to deserve honors and not have them than to have them and not deserve them."
     -- Mark Twain 


 

Sent from my Galaxy tablet phone.  Please excuse my brevity.
For any grammatic/spelling errors, there is no excuse.
++


"Morgan, Paul" <Paul.Morgan@xxxxxxxxxxx> wrote:

> Pete,
>
> If you use CPYFRMIMPF with the RCDDLM(*CRLF) and FROMRCD(2) parameters
> you can skip the .txt futzing in your process.
>
> 1) Save from Excel (I prefer CSV format)
> 2) FTP
> 3) Create table with columns
> 4) CPYFRMIMPF (from FTP import file to table)
>
> Paul Morgan 
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Pete Hall
> Sent: Wednesday, November 09, 2011 8:54 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: Upload excel sheet to DB2 file on AS400
>
> On Wed, 09 Nov 2011 16:52:42 -0500, Ashish Kulkarni wrote:
>
> > Hi
> > I have an excel sheet how can i upload this file to AS400 DB2 table,
> is
> > there any excel plugin to do so or iseries navigator method?
>
> I usually save the worksheet as a tab delimited .txt document from
> excel, 
> delete the column headings, and the trailing carriage return/linefeed 
> with a windoz editor like textpad, ftp it to my home directory in the
> i, 
> create an import table having columns that exactly match the excel 
> document, then copy the tab delimited file to the table with
> cpyfrmimpf. 
> Sounds more complicated than it really is. It's pretty fool-proof, and
> it 
> works every time.
>
> -- 
> Pete Hall
> pete@xxxxxxxxxxxxxx
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.