Get started Bring yourself up to speed with our introductory content.

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.

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

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

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close