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

If you have Client Access just use the top 'Send' button on your emulation
screen.  This transfers data from the PC (as CSV file) to the AS400. The
last icon at the top of the data transfer screen 'create AS400 database
file' will guide you through the whole process AND create the AS400 DDS file
for you.  A good tip is to take the title fields away otherwise the AS400
will analyse these fields when deciding on the best data type.  When the
AS400 creates the DDS it will show you the fields it is going to create and
you can change them if you would rather a different data type.

The only time I can think of when this wouldn't be suitable is of you didn't
have client access or it was something you had to automate to happen daily
etc.

Cheers Jen



-----Original Message-----
From: Chuck Lewis [mailto:clewis@iquest.net]
Sent: 24 July 2002 21:30
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

_______________________________________________
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.