RE: AS/400 to Excel Data Transfer

["MCPARTLAND, Stan" <stanley.mcpartland@xxxxxxxxxx>]

Not sure what you mean by "automating", but if you want to initiate the
transfer from Excel use ODBC.  VBA in Office 97 on supports SQL statements
in the code.  If you are still on Office 95, use MS Query within an Excel
macro.

Regards,
Stan

-----Original Message-----
From: JDE Temp 1 [mailto:JDETEMP1@legacyptr.com]
Sent: Thursday, March 23, 2000 10:11 AM
To: MIDRANGE-L@midrange.com
Subject: AS/400 to Excel Data Transfer


Hi Falks,

The present way of automating an AS/400 DB2 file to be transfered as an
Excel worksheet is using the IBM's Client Access. Is there any other way we
could have this done w/o using Client Access. For example, can we use
Rumba/400? Or is there any other way doing this?

Nimal.  

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