× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2007

Re: Uploading data to iSeries from Excel

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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.