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

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.

This was last published in November 2005

Dig Deeper on iSeries SQL commands and statements

All
Get Started
Problem Solve

Running AS/400 query to find records based on date

Tracking data changes on IBM i with triggers

Convert a numeric physical file to a character in SQL without leading zeros

Inserting data from a CTE into a file in SQL

Running AS/400 query to find records based on date

Tracking data changes on IBM i with triggers

Convert a numeric physical file to a character in SQL without leading zeros

Inserting data from a CTE into a file in SQL

Running AS/400 query to find records based on date

Tracking data changes on IBM i with triggers

Convert a numeric physical file to a character in SQL without leading zeros

Inserting data from a CTE into a file in SQL

Please create a username to comment.

Build a comprehensive outline for your data center budget

Open source virtualization expands VM hardware and OS options

4 considerations for choosing a private cloud provider

Dig Deeper on iSeries SQL commands and statements

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.