RE: Upload Excel spreadsheet to AS/400

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Michael,

Have you considered using IBM's OLEDB driver, and writing a quick little
transfer program within VBA?


Regards,

John Taylor
Canada

> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of James W. Kilgore
> Sent: Wednesday, December 06, 2000 6:17 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Upload Excel spreadsheet to AS/400
>
>
> 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
> +---

+---
| 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
+---