Re: Uploading Excel to AS/400

The only problems I have run into when trying this is when using Excel97.
I could not get it to save to a BIFF5 format in order to upload back to the
400.  When I used Excel95 everything worked great.  Download as a BIFF5
open Excel95 make your changes and upload.

Bryan Dietz
3X Corp.
---------------------------------------------




Pete Hall <peteh@inwave.com> on 04/30/98 10:48:28 PM

Please respond to MIDRANGE-L@midrange.com
                                                              
                                                              
                                                              
 To:      MIDRANGE-L@midrange.com                             
                                                              
 cc:      (bcc: Bryan Dietz/Columbus/3X Corp)                 
                                                              
                                                              
                                                              
 Subject: Re: Uploading Excel to AS/400                       
                                                              






At 06:47 AM 4/30/98 -0700, Jim Waymire wrote:
>Can someone tell me how they upload an excel worksheet to an as/400
>file?  I get an "unspecificed error" everytime I run it....
Jim,
I had the same problem. In self defense, I wrote a PC utility that will
transform a tab delimited file (which excel can produce) to a positional
record that can be FTP'd to the AS/400. If you'd like a copy, it's free and
on my web site. The program name is FLATULATE. (Sort of gives you a flavor
for how much I appreciated this CA functionality.)
Pete

Pete Hall
peteh@inwave.com
http://www.inwave.com/~peteh/
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@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 unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---