Exporting AS/400 To Excel

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...

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?

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

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...

CL Program

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 file to? and can I run both queries this way? thanks,