• How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • Receiving an XML file to RPG

    Hi, I need to receive XML files (of fixed format) to my RPGLE program (not free format RPG) and do some calculations. Can I do this without purchasing any tools (free tools can be used)? Please let me know if anyone has done something similar. Regards, Kiron

    Kiron5 pointsBadges:
  • Export multiple files to Excel using CL

    Hello, I have these queries on a job schedule now and I want to export them to Excel using CL. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two files to? And can I run both queries this way?

    Querys100 pointsBadges:
  • Migrate application from UNISYS to AS/400

    How can we migrate an application currently running on the UNISYS platform to AS/400 platform. A major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database.

    126170 pointsBadges:
  • AS/400 data transfer version 1.2 or 2.0

    i have 2 different datatransfer files to get data from an AS/400 to excel. one is version 1.2 and the other has version 2.0 in the description what is the difference, cause i now got an other version of client access installed and the 1.2 version is not working anymore

    DHLer20 pointsBadges:
  • Problem with AS/400 data transfer to Excel

    I have been downloading AS400 query files to Excel spreadsheets for many years using the Data Transfer utility in Client Access. There has never been any problem. Now suddenly all of the output data has started transferring to Excel as long hexadecimal strings and is unusable. I asked the IT folks...

    JDK55 pointsBadges:
  • Convert as400 file to Excel and Pdf

    I would like to transfer a PF data into Excel , my add ins not working. Can u provide me any other ways to do that.

    As400programm10 pointsBadges:
  • Records limited when downloading from AS400 to Excel

    When downloading from AS400 to excel, my records are limited to 16383. I can't find the place on Iseries FTP Version 5 release 2 to stop it from limiting the records. Please help.

    Worksalot15 pointsBadges:
  • Export AS/400 to MS Access

    My auditor wants me to export files from my AS/400 to MS Access and I don't have a clue how to do that or if it can be done. I hope someone does.

    Dowagiac5 pointsBadges:
  • Data Transfer from AS400 to excel

    i need to download data from As400 to Excel using TTO option. How to download the description of the fields instead of field names. I have tried with the COLHDG & TEXT keywords in the DDS of the PF. But, the records are getting downloaded with the filed names only. Please revert to me ASAP if you...

    Saranyahere5 pointsBadges:
  • AS400 Transfer to Excel with a Locked Cell

    Hi everyone I hope someone can help me with this. I have an Excel template for a download for a group of users. The cell containing the formula was requested by management to be locked due to some of the users incorrectly removing the formula or leaving old data in cells outside the screen view...

    Patcoad30 pointsBadges:
  • db2 to excel

    i was tryin to import from db2/400 into excel but when i did. the description came up in a different language...in db2/400 the description was in araic then when i imported in excel it came up a different language?? any idea plz help  thank you

    Doodoo5 pointsBadges:
  • as400 to excel

    how to move the control from as400 to excel and copy the data from excel again move to as400

    Selva11kumar225 pointsBadges:
  • Data transfer from AS400 to Excel 2007 Stops at 16,xxx rows

    I am using client server to access my AS400.  i downloaded and installed it within the last 6 months i have the excel add on installed and it seems to be working well on tables with less than 16,xxx rows.  1. can anyone help me find out if there is a more up to date add on for excel 2007? 2. My...

    Ringside35 pointsBadges:
  • Create .csv file on IFS folder in AS/400

    Please help to create .csv file in as/400 (V4R3). Please provide me the steps to create .csv file on IFS path on AS/400.(V4R3).

    Samule400160 pointsBadges:
  • Arabic Text In AS/400 to Excel

    Arabic Text when transfered to from AS400 to Excel displays garbage. Is there an add in I need to install?

    STARter20095 pointsBadges:
  • We are runing V5R1 OS400, how do I write to CSV file

    We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.

    Proy5 pointsBadges:
  • BRMS – Save from AS/400 to Mainframe, then Mainframe to SAP

    Any one tell me using BRMS how to save the library while it's in active stage.

    5459130 pointsBadges:
  • AS400 Physical file conversion to xml file

    Hi, i need to write an RPGLE program to convert an as400 physical file to an xml file. Does anyone have a sample code for it? Thanks in advance.

    Siri55 pointsBadges:
  • generating excel on server

    I want to generate excle on server and store. I had copied spl file to pf but how can i generate excle on server.

    151015 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following