RE: AS/400 to Excel Data Transfer

["Leisk, Andrew" <aleisk@xxxxxxxxxxx>]

Title: RE: AS/400 to Excel Data Transfer

If you have the ASC - SEQUEL product you can use SEQUEL to query a file with the output in Excel format to a directory in QDLS: 

For example:
 EXECUTE    SQL('SELECT * FROM MY400FILE') TOFLR(AXXX) +   
              TODOC(MYWS.XLS) PCFMT(*XLS) REPLACE(*YES)

----------
From:   JDE Temp 1[SMTP:JDETEMP1@legacyptr.com]
Reply To:       MIDRANGE-L@midrange.com
Sent:   Thursday, March 23, 2000 12:10 PM
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
+---