RE: Using Excel spreadsheet data on the AS/400

[<groyle@xxxxxxxx> (Gordon S. Royle)]

We did it from the AS/400 side with CL/RPG. What we did basically was modify 
an FTP batch program example that we got from "Who knew what u could do with 
RPGIV", implement a program to go get the IP address (that we got from the 
RPG/400 archives) and put then together in a CL program. As long as you have 
some kind of FTP Server running on your PC (we use Serv-U), it works 
flawlessly. 

Gord Royle
Cott Corporation - Canada
---------- Original Text ----------

From: Cindy Hudson <cindy_hudson@lifecare.to>, on 3/1/01 12:11 PM:

My question regarding downloading a file to the PC is:
Can you automate the client access button so no user has to click it to
begin the process?
Either in RPG or CL?

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Alex A Moore
Sent: Thursday, March 01, 2001 7:37 AM
To: RPG400-L@midrange.com
Subject: RE: Using Excel spreadsheet data on the AS/400

Frank,

        There are several ways, one of the neatest, in my opinion, is the
new
database file creation wizard within the file transfer feature of Client
Access Express (latest version) and even simpler add-in for Excel in the
current Beta version.  Simply click on the upload button from within your
Excel spreadsheet, fill in the requested information:

Does your data have column headings in the first row?

Name of trnasfer file if you want to save it.

Library and Name of database file.

etc.

- then the file is created, and data is transfered.

I used it just this morning to upload data from one of our customers, a
large retailer, to verify their data (store addresses) against our database.

Works like a charm.  If you need more details - don't hesitate.  If you have
Client access express - experiment.


Alex

-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of Frank Kany
Sent: Thursday, March 01, 2001 8:47 AM
To: RPG Mailing List (E-mail)
Subject: Using Excel spreadsheet data on the AS/400


Someone I'm working with is trying to use data from an excel spreadsheet on
the AS400.  If anyone knows of a way to do this please let me know.

TIA

Frank

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---




_______________________________________________________________

Cott - The Leader in Premium Retailer Brand Beverage Innovation. 
_______________________________________________________________
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---