RE: AS400 to EXCEL

[rob@xxxxxxxxx]

Maybe instead of CPYTOIMPF you need CPYFRMIMPF.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Tracy Ball" <TBall@xxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
05/13/2003 03:11 PM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     "RPG programming on the AS400 / iSeries" 
<rpg400-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        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.