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

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'm torn between FTP and cpyfrmimpf after saving the Excel files in an IFS
directory in your favorite text format.  FTP might be marginally easier to
script. If there's a lot of files involved, the real annoyance will be
keying in all the from and to names correctly and building the destination
files if they're not there already.  I've never used the Synapse file
transfer.  Is it great grandchild of ETU?

Is there a way to eliminate the middle person and get text files directly
from the Unix box?  That would be my fantasy first choice.  FTP into
intermediate file in IFS or direct to database file.

> -----Original Message-----
> From: Chuck Lewis [mailto:clewis@iquest.net]
> Sent: Wednesday, July 24, 2002 1: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 ?
>
> 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
>
NOTICE:
All e-mail sent to or from this e-mail address will be received or otherwise
recorded by The Sharper Image corporate e-mail system and is subject to
archival, monitoring, review by and/or disclosure to Sharper Image security
and other management. This message is intended only for the use of the
addressee and may contain information that is privileged and confidential.
If you are not the intended recipient, dissemination of this communication
is prohibited.