RE: Downloading Excel File to Physical File

["Alexander, April" <AAlexander@xxxxxxxxxx>]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
I do this using FTP and CPYFRMIMPF.  FTP the csv file to the AS400.  Create
a PF with fields laid out exactly like your CSV.  Use the CPYFRMIMPF to move
your FTP file to this PF.  It works beautifully, even to the mapping of
decimals.


-----Original Message-----
        From:   JMBauman@wardtrucking.com [SMTP:JMBauman@wardtrucking.com]
        Sent:   Thursday, November 01, 2001 2:19 PM
        To:     rpg400-l@midrange.com
        Subject:        Downloading Excel File to Physical File


        Hi Everyone.  I need to download an excel file into a physical file.
I was
        just going to download it to a non-dds file and use it as a program
        described file but I thought I would run it by the group.  Thanks in
        advance for all your help

        John M. Bauman
        Lead Programmer
        Ward Trucking
        Second Avenue & Seventh Street, Greenwood
        Altoona, Pa 16602

        Voice: (800) 458-3625 Ext. 284
        Voice Direct: (814) 947-1284 (Direct Line)
        Fax: (814) 944-5470
        JMBauman@Wardtrucking.com

        Visit our website at http://www.wardtrucking.com

        _______________________________________________
        This is the RPG programming on the AS400 / iSeries (RPG400-L)
mailing list
        To post a message email: RPG400-L@midrange.com
        To subscribe, unsubscribe, or change list options,
        visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
        or email: RPG400-L-request@midrange.com
        Before posting, please take a moment to review the archives
        at http://archive.midrange.com/rpg400-l.