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

If your database files on the 400 have no packed fields, and the Unix files
are fixed length, you're in clover. Just ftp to the physical file.

Otherwise, if you can get some kind of delimited file on the Unix box, ftp
to IFS, then quote rcmd cpyfrmimpf withe the appropriate separators. And
I'm sure there's a way to do a for each kind of thingy in bash or csh or
whatever. Or perl. Or maybe sed or awk.

At 01:59 PM 7/24/02 -0700, you wrote:
>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.