Re: Excel Transfer

[Ken.Slaugh@xxxxxxxxxx]

Whether this helps or not... Excel easily imports Tab delimited records
from a flat text file.

It is also quit easy for an Excel macro to read the file through
NetServer/400 after you create the file with the CPYTOPCD command. The
macro can also filter and/or parse the data into desired worksheet ranges.

Also... You should look into the CPYTOSTMF command and consider using it
instead of CPYTOPCD.


Ken Slaugh  (707) 795-1512 x118
Chouinard & Myhre, Inc.
AS/400 Professional Administrator/MSE
Client Access Specialist
http://www.cm-inc.com/


                                                                                
            
                    keith.nolan@dubport                                         
            
                    .ccs.ie                    To:     MIDRANGE-L@midrange.com  
            
                    Sent by:                   cc:                              
            
                    owner-midrange-l@mi        Subject:     Excel Transfer      
            
                    drange.com                                                  
            
                                                                                
            
                                                                                
            
                    05/03/01 10:31 AM                                           
            
                    Please respond to                                           
            
                    MIDRANGE-L                                                  
            
                                                                                
            
                                                                                
            




Hi all,

If I want to automate the transfer of a database file from our AS/400 into
an excel file on a folder how do I get the transfer command 'CPYTOPCD' to
translate into an Excel File like you can do on the Client access file
transfer....

TIA..

Keith
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---




+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---