RE: AS400 to EXCEL

["Mike Haston ** Data" <MHaston@xxxxxxx>]

As far as the QDLS, this was already set up here and at any place I've been.  
To map to my computer I went into Windows Explorer/Tools/Map Network Drive and 
found it.  You'll need authority, yadda yadda yadda.

I'm sure someone on here will be able to tell you exactly what you need to 
request if the QDLS isn't set up.  Sorry.


-----Original Message-----
From: hrishikesh kotwal [mailto:hdkotwal@xxxxxxxxxxx]
Sent: Friday, May 16, 2003 10:30 AM
To: rpg400-l@xxxxxxxxxxxx
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.