ISeries Import/export Questions and Answers

Recent IT Questions

1 - 6 of 6
<<PREVIOUS 1 NEXT>>

How to create iSeries printer file width greater than 378 limit?

Is it possible to create an iSeries spooled printer file with a width greater than the 378 character limit on the CRTPRTF command? Possibly using an AFP function? The spooled file is intended to be imported into the COMPLEO utility for conversion to EXCEL. There is no need to print the spooled...

View Answer   |  Jun 26 2009  8:47 PM GMT
iSeries, CRTPRTF, Symtrax Compleo
asked by Shuete

  25 pts.

Is it possible to FTP files from an iSeries using comma delimited to a PC server?

Is it possible to FTP files from an iSeries using comma delimited to a PC server? Thanks. Moderator Note: This is a submitted question

View Answer   |  Jun 15 2009  6:24 PM GMT
iSeries FTP, Comma-delimited, iSeries import/export
asked by BrentSheets

  6535 pts.

How can I convert all the records from a Physical File to Exces ?

I would like to know how can I achieve this ? and I am working on V4R4. Example : PF1 contains 100 records , I need to convert this into Exces .

asked by Chrisjam

  95 pts.

import data from excel 2007 to iseries

how do you import data from excel 2007 to iseries

View Answer   |  Nov 25 2008  3:54 PM GMT
iSeries, Microsoft Excel, Excel 2007
asked by JimC1128

  5 pts.

AS/400 to Excel

Hi Someone, I am using FTP to send a data file fromthe iseries to the server as a .txt file usint put statement. Can anyone suggest how I would sent the file direct to an Excel spreadsheet, preferable to a pre-formatted sheet. Thanks.

View Answer   |  Nov 10 2008  4:00 AM GMT
OS/400, iSeries, Microsoft Excel
asked by Tjgm88

  440 pts.

Transfer Data from iSeries to Excel

Hi Everyone, Could someone provide VBA code to automate the Transfer of data from the iSeries into an Excel 2003 Spreadsheet. Currently we have to manually use the iSeries Excel Add-In. All fields are left default except the Library/File field where we enter PRODDTA/F56EXT. The data then...

View Answer   |  Jun 19 2008  4:14 AM GMT
iSeries, Microsoft Excel, iSeries import/export
asked by Mblair.au

  25 pts.

1 - 6 of 6
<<PREVIOUS 1 NEXT>>