RE: Upload Excel spreadsheet to AS/400

["Alex Moore" <alexm@xxxxxxxxxxxxxxxx>]

The CA Express Data Transfer tools wizard will _CREATE_ the data base file
on the AS/400 from an Excel spreadsheet.  You need to understand the data
type relationships.  Create a spreadsheet with every type of Excel data you
might want to use, with reasonable column headings, and use the wizard to
upload.  This let's you see how the various Excel data types translate to
AS/400 data types.

Alex



> maybe you can utilize an intermediate program like access to do you map.
>


>
> 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.
>
> As we know, we get decimal data crashes if there is a space in a numeric
> field.
>
> How would you upload to the as400 from an excel spreadsheet with numeric
> data in it--considering that IBM does not like spaces in numeric fields.
>
> +---

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