Re: Uploading data to iSeries from Excel

[John Ross <jross-ml@xxxxxxxxxxxxxxx>]

I would look at     Data, Text to Columns    in the Excel spreadsheet

If that does not work I would move the column out past the end of the 
other columns in the spreadsheet and look at putting in its place one 
that uses an If statement to put something you can use in the column.

If that does not work what type of field is it in Excel and what type 
are you trying to put it into, or are you trying to just create the file 
on the system i from the spreadsheet.

John Ross
http://www.netshare400.com/ShowMe.html

Bob Anderson wrote:
> Good Morning,
>         I am moving an application from Microsoft Access to the iSeries.
> In moving the data from Access I export it to an Excel spreadsheet. This
> has worked well but now I've run into some True/False fields that I
> can't load into the iSeries using the Transfer to iSeries command in
> excel.  Does anyone have a best practice for these type fields.
>