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

Use MS Access. Create a table(s) in Access that is linked to the file(s)
on the 400, Then import the csv file(s) and use an update query to copy
the contents from the imported table(s) to the linked table(s).

Joe

>>> clewis@iquest.net 07/24/2002 13:29:57 >>>
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

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.