RE: Converting XL file to AS/400 File

[Ken Slaugh <ken.slaugh@xxxxxxxxxx>]

The most obvious way would be to develop a Excel VBA macro to reference a
CA/400 ODBC connection. Doing so will allow for posting of Excel rows to DB2
records via a SQL Insert statement.

Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Network Administrator / MSE
Client Access/400 Specialist
http://www.cm-inc.com/


-----Original Message-----
From: a b [mailto:eagle_291@yahoo.com]
Sent: Wednesday, February 16, 2000 2:21 PM
To: RPG400-L@midrange.com
Subject: Converting XL file to AS/400 File


I was wondering if someone could suggest what would be
the best way to convert an Excel file to an AS/400
physical file.  Would I have to convert the file to a
flat/stream file, then write an RPG program to
partition the data, or could I just upload the file
into an existing physical file?

Any help would greatly be appreciated.

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.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
+---