RE: Using Excel spreadsheet data on the AS/400

Fixed length text files can cause problems unless you're very careful about
column formatting.  It's easy to forget that a column that has a bunch of
two and three digit numbers in it has to have a length of say, 9 to come in
to the file on the 400 correctly.  



> -----Original Message-----
> From: Vladimir Ivanov [mailto:vivanov@medtac.com]
> Sent: Thursday, March 01, 2001 7:40 AM
> To: RPG400-L@midrange.com
> Subject: Re: Using Excel spreadsheet data on the AS/400
> 
> 
> Save the file as type : Formatted text(space delimited). This 
> will create a *.prn
> file.
> After just transfer file through FTP to AS400(FTP is better 
> than Client Access in
> this
> case, but you can use CA too)
> 
> Frank Kany wrote:
> 
> > 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
+---