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

Don't know what you decided but I would go with the CSV format and use
Synapse IP Client to get it directly into an AS400 database.  OS/400
versions don't matter with Synapse and it's very fast.

Jerry

----- Original Message -----
From: Chuck Lewis <clewis@iquest.net>
To: Midrange-L <midrange-l@midrange.com>
Sent: Wednesday, July 24, 2002 1:29 PM
Subject: Best Way to get Excel data to AS/400


> 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 ?
>
> We are running the Synapse TCP/IP emulation product and it has
> Upload/Download GUI programs aka CA. I've done this before but it can be a
> hassle with numbers, etc.
>
> And then there is also the FTP option which I would think would be a good
> option but I have never done much more than uploads of text information
with
> that...
>
> So what's the consensus on best way to do this ? We are on V4R5.
>
> Thanks !
>
> Chuck