Re: Using Excel spreadsheet data on the AS/400

Since you are asking this on the RPG list and not the midrange list I
assume that you are trying to access the file using RPG right?

If so, have you looked at the tips given for accessing files in the IFS
using RPG?  Some of these tips are in the Redbook 'Who Knew you could do
that with RPG...'.  Another source for tips is sample programs.  You might
want to search the archives for SAMPLE and IFS.  I've seen some examples in
the code SNDEMAIL also.  As far as getting the layout of the excel
spreadsheet - whew!  You might be better off transitioning using a comma
separated variable file as a go between.

Rob Berendt

==================
Remember the Cole!


                                                                                
                                         
                    "Frank Kany"                                                
                                         
                    <frank.kany@hanover        To:     "RPG Mailing List 
\(E-mail\)" <RPG400-L@midrange.com>             
                    foods.com>                 cc:                              
                                         
                    Sent by:                   Subject:     Using Excel 
spreadsheet data on the AS/400                   
                    owner-rpg400-l@midr                                         
                                         
                    ange.com                                                    
                                         
                                                                                
                                         
                                                                                
                                         
                    03/01/01 08:47 AM                                           
                                         
                    Please respond to                                           
                                         
                    RPG400-L                                                    
                                         
                                                                                
                                         
                                                                                
                                         




Someone I'm working with is trying to use data from an excel spreadsheet on
the AS400.  If anyone knows of a way to do this please let me know.

TIA

Frank

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



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