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