RE: AS400 to EXCEL

["hrishikesh kotwal" <hdkotwal@xxxxxxxxxxx>]

   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