RE: AS400 to EXCEL

Since people are asking about Excel to DB2, Kemetech has a product for this
as well.  We have bought it, but no one has really used it yet, so I can't
comment.

Mike E.




                                                                                
                                    
                    "Mike Haston **                                             
                                    
                    Data"                     To:     "RPG programming on the 
AS400 / iSeries"                      
                    <MHaston@xxxxxxx>          <rpg400-l@xxxxxxxxxxxx>          
                                    
                    Sent by:                  cc:                               
                                    
                    rpg400-l-bounces@xx       Subject:     RE: AS400 to EXCEL   
                                    
                    drange.com                                                  
                                    
                                                                                
                                    
                                                                                
                                    
                    05/13/2003 04:36 PM                                         
                                    
                    Please respond to                                           
                                    
                    RPG programming on                                          
                                    
                    the AS400 / iSeries                                         
                                    
                                                                                
                                    
                                                                                
                                    




I used to use CPYTOPCD and send it over as a .prn file and that could be
messy with what you are talking about.  Not to mention it required the
users to think briefly when using the import wizard in Excel!

CPYTOIMPF has worked very easily for me *so far*.  Like Bob said, open it
in Excel, no wizard or anything and save it as your .xls file.


-----Original Message-----
From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
Sent: Tuesday, May 13, 2003 3:53 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: AS400 to EXCEL


And the reply that comes up on that all the time is if you have a string
field that just happens to be all numeric, it makes it numeric.  Or some
such argument.  I think that's in the archives also.  I just remember
something like that.

Rob Berendt

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