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...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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.