RE: Downloading Excel File to Physical File

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.