RE: Copy to Excel Spreadsheet

[Clay Merrick <Clay.Merrick@xxxxxxxxxxxxxxx>]

CL pgm (requires PCO services and Network presence of client)

------------- 7 data records excluded
------------------------------------------
             DCL        VAR(&PcoFlg ) TYPE(*char) LEN(  4) VALUE('*OFF')

             DCL        VAR(&PcCmd  ) TYPE(*char) LEN(123)



------------ 31 data records excluded
------------------------------------------
/* start PC Command environment
*/
             STRPCO



             MONMSG     MSGID(IWS4010) EXEC( +

                         CHGVAR VAR(&PcoFlg) VALUE('*ON'))

------------ 27 data records excluded
------------------------------------------
              CHGVAR     VAR(&PcCmd) VALUE('cwbtf +

                           C:\WINDOWS\Desktop\Traili~1\trailingblanks0+

                           5.dtf')

------------- 2 data records excluded
------------------------------------------
/* Client Access file transfer
*/
             STRPCCMD   PCCMD(&PcCmd) PAUSE(*NO)

------------ 15 data records excluded
------------------------------------------
ENDPGM:

             RCLRSC

             ENDPGM

****************** End of data
*************************************************

-----Original Message-----
From: Sunitha Duraivelan [mailto:sundurai2002@yahoo.com]
Sent: Friday, July 26, 2002 2:08 AM
To: rpg400-l@midrange.com
Subject: Copy to Excel Spreadsheet


--
[ Picked text/plain from multipart/alternative ]

Hi all,
I am looking to automate the process of downloading a query/400 outfile to
an Excel spreadsheet.
I am not sure if we can schedule the client access 'Data transfer from
AS/400' option to do the job automatically.
I am looking for a CL command to do this. Can anyone help me please.
Thanks,
Sunitha.




---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.