Bypassing the 65,000 row limit in Excel via the iSeries

When you need to upload more than 65,000 rows of data from the iSeries to Excel, use the "Receive files from Host icon". Learn how in this Search400.com tip.

Denise Terrell

Published: 15 Nov 2005

When you need to upload more than 65,000 rows of data from the iSeries to Excel, use the "Receive files from Host...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

icon". In the PC box, click on the details button and select the file type as BIFF7 (MS Excel 7) from the drop down box. Click on the details button next to the file type drop down box and check all the boxes in the window. Continue uploading as normal. The data will be spread over multiple worksheets.

An example Ajax file upload with pure JavaScript

Creating a cluster with shared storage in Proxmox

Three ways to import Power BI data into SharePoint

Reduce the cost of virtualization with open source Proxmox

Get a template to estimate server power consumption per rack

When the chips are down, Intel turns to VMware's Pat Gelsinger

Intel CEO Bob Swan to be replaced by VMware's Pat Gelsinger