RE: AS400 to EXCEL

["Mark A. Manske" <mmanske@xxxxxxxxxxxxxxxxxx>]

CPYFRMIMPF is the command you want to use,
this will take the csv file and dump it into
a predefined 400 database file.

HTH
Mark


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Tracy Ball
Sent: Tuesday, May 13, 2003 3:12 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: AS400 to EXCEL


I have seen this thread before and think I am still missing something
somewhere.  

If I have a CSV file and I want to be able to get it into a basic field
defined DDS file, can I use the CPYTOIMPF command?  Right now I have been
taking it into FoxPro and then saving it back out as an .sdf type file.
Then the CPYFRMPCD command takes it from there.

Tracy L. Ball
The Jackson Group
Sr. Programmer/Analyst 
(317) 781-4600 ext. 3107


-----Original Message-----
From: Bob cozzi [mailto:cozzi@xxxxxxxxx]
Sent: Tuesday, May 13, 2003 2:46 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: AS400 to EXCEL


Excel will read the CSV file that CPYTOIMPF generates


Bob Cozzi
Cozzi Consulting
www.rpgiv.com


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of hrishikesh kotwal
Sent: Tuesday, May 13, 2003 2: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.


_______________________________________________
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.