Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Excel to iSeries transfer bug?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel to iSeries transfer bug?

    I am uploading an Excel 2003 spreadsheet to a physical file on the iSeries (V5R3) using BIFF Excel 8 format. If the last column or columns in the spreadsheet are empty, then the corresponding fields in the physical file will get data from the last column containing data in the spreadsheet. If I put a single blank or any other value in these columns, the conversion works fine. Example 1: spreadsheet columns = '1' '2' [empty] [empty] physical file fields = '1' '2' '2' '2' Example 2: spreadsheet columns = '1' '2' '3' '4' physical file fields = '1' '2' '3' '4' Any ideas? Thanks in advance for your help. Kevin
Working...
X