1
  • 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • Data transfer from EXCEL using AS400 add-in to AS400 physical file

    If EXCEL is the starting point, how can I make the user specify the file name to transfer the EXCEL info to. Or how can I lock a predetermined file until after the transfer is complete? Thanks in advance

    BobK5 pointsBadges:
1

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