RE: Best Way to get Excel data to AS/400

[Scott Mildenberger <Smildenber@xxxxxxxxxxxx>]

Chuck,

The best way is to put the .csv file in the IFS, using Ops Nav or a mapped
network drive, and then using CPYFRMIMPF to copy that data to a database
file.  Then you can process that database file any way you need to.  I have
done this a lot, just yesterday in fact, and it is very quick and easy to
exchange data with other systems.

Scott Mildenberger

> -----Original Message-----
> From: Chuck Lewis [mailto:clewis@iquest.net]
> Sent: Wednesday, July 24, 2002 2:30 PM
> To: Midrange-L
> Subject: Best Way to get Excel data to AS/400
> Importance: High
>
>
> Hi Folks,
>
> We are needing to get data from an RS/6000 to the AS/400.
> These folks can
> download the files we need via a report writer into Excel and they are
> emailing them to us.
>
> We can save this information to a CSV file, TXT file, etc.
>
> My question is what is the most "painless" way to get this data to our
> AS/400 ?
>