× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.