RE: AS400 to EXCEL

[SHOLMES@xxxxxxxxxxxxxx]

I don't know if this would help but I just found it while doing another 
search at google. http://www.dbg400.net/crtcsv.html






"hrishikesh kotwal" <hdkotwal@xxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
05/16/2003 10:29 AM
Please respond to RPG programming on the AS400 / iSeries

 
        To:     rpg400-l@xxxxxxxxxxxx
        cc: 
        Subject:        RE: AS400 to EXCEL


   Hi Mike:

 

   How did you map the "/QDLS/yourfolder/yourfile.csv" to
   "Q:\yourfolder\yourfile.csv"?

 

   What will I need to tell me network administrator to do this?

   Regards,
 
   Hrishikesh Kotwal
 
   >From: "Mike Haston ** Data" <MHASTON@xxxxxxx>
   >Reply-To: RPG programming on the AS400 / iSeries 
<RPG400-L@xxxxxxxxxxxx>
   >To: "RPG programming on the AS400 / iSeries" <RPG400-L@xxxxxxxxxxxx>
   >Subject: RE: AS400 to EXCEL
   >Date: Tue, 13 May 2003 16:03:13 -0400
   >
   >Give it a whirl ... or at least the CPYTOIMPF portion ;)
   >
   >
   >PGM
   >
   >CPYTOIMPF FROMFILE(yourLib/yourFile) +
   > TOSTMF('/QDLS/yourFolder/yourFile.CSV') +
   > MBROPT(*REPLACE) STMFCODPAG(*PCASCII) +
   > RCDDLM(*CRLF)
   >
   >STRPCO
   >MONMSG MSGID(IWS4010)
   >STRPCCMD PCCMD('Start Q:\yourFolder\yourFile.CSV') PAUSE(*NO)
   >
   >ENDPGM
   >
   >
   >
   >
   >
   >-----Original Message-----
   >From: hrishikesh kotwal [mailto:hdkotwal@xxxxxxxxxxx]
   >Sent: Tuesday, May 13, 2003 3:20 PM
   >To: rpg400-l@xxxxxxxxxxxx
   >Subject: RE: AS400 to EXCEL
   >
   >
   > Hi all:
   >
   >
   >
   > I did find a lot interesting things @ midrange regarding converting 
PF
   to
   > an Excel file. But still a few questions remain:
   >
   > Using CPYTOIMPF, I was able to create Source Member containing 
formatted
   > data i.e. character strings in ' " ' and numbers separated by ' , '.
   >
   > But I would like to generate an Excel file from this member without 
any
   > human intervention i.e. programmatically. How do I achieve that?
   >
   >
   >
   > Please advise.
   >
   > Regards,
   >
   > Hrishikesh Kotwal
   >
   > >From: Buck Calabro <BUCK.CALABRO@xxxxxxxxxxxx>
   > >Reply-To: RPG programming on the AS400 / iSeries
   <RPG400-L@xxxxxxxxxxxx>
   > >To: RPG programming on the AS400 / iSeries <RPG400-L@xxxxxxxxxxxx>
   > >Subject: RE: AS400 to EXCEL
   > >Date: Tue, 13 May 2003 08:07:53 -0400
   > >
   > >The FAQ has some entries dealing with this. http://faq.midrange.com
   > > --buck
   > >_______________________________________________
   > >This is the RPG programming on the AS400 / iSeries (RPG400-L) 
mailing
   > list
   > >To post a message email: RPG400-L@xxxxxxxxxxxx
   > >To subscribe, unsubscribe, or change list options,
   > >visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
   > >or email: RPG400-L-request@xxxxxxxxxxxx
   > >Before posting, please take a moment to review the archives
   > >at http://archive.midrange.com/rpg400-l.
   > >
   >
   > 
----------------------------------------------------------------------
   >
   > Dreaming of a holiday? Make it happen. In Switzerland!
   >_______________________________________________
   >This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
   list
   >To post a message email: RPG400-L@xxxxxxxxxxxx
   >To subscribe, unsubscribe, or change list options,
   >visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
   >or email: RPG400-L-request@xxxxxxxxxxxx
   >Before posting, please take a moment to review the archives
   >at http://archive.midrange.com/rpg400-l.
   >
   >
   >_______________________________________________
   >This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
   list
   >To post a message email: RPG400-L@xxxxxxxxxxxx
   >To subscribe, unsubscribe, or change list options,
   >visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
   >or email: RPG400-L-request@xxxxxxxxxxxx
   >Before posting, please take a moment to review the archives
   >at http://archive.midrange.com/rpg400-l.
   >

 ----------------------------------------------------------------------

   Bridge gaps. Reconnect with old friends. On batchmates.com
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.