RE: Using Excel spreadsheet data on the AS/400

Save your spreadsheet to the IFS with the csv attributes, and then run the cpyfrmimpf to copy the delimited file into an as/400 pf.

hth, tim

-----Original Message-----
From:   Cindy Hudson [SMTP:cindy_hudson@lifecare.to]
Sent:   Thursday, March 01, 2001 9:11 AM
To:     RPG400-L@midrange.com
Subject:        RE: Using Excel spreadsheet data on the AS/400

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