Re: Upload Excel spreadsheet to AS/400

["James W. Kilgore" <eMail@xxxxxxxxxxxxxxxxxxx>]

Michael,

This is a problem we all face.  Basically all fields -must- be input as
alpha fields and you must convert the numeric fields based upon your
standards (leading minus or trailing, comma separators for thousands or
pennies, decimal point, etc.)

There has been a lengthy discussion this month on the rpg400-l list at
midrange.com about this very topic.

Michael_Hennessy@doubleday.com.au wrote:
> 
> Hi all,
> 
> one of our A/Ps has the following requirement:
> 
> I have an excel spreadsheet that has numeric data in most columns and also
> some columns with alpha data.
> The requirement is that I need to upload this to the As400 for use in a
> program that converts this data into an existing file on the As400.
>
+---
| 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
+---