transferring data from iSeries to Excel 2007
iSeries Access, Excel 2007, iSeries database
Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows? Question
iSeries Access, Excel 2007, iSeries database
Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows? 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
Well, seeing that Excel has a row limitation of 65536... The only way to download more rows than that would be to insert them into Access! Or ask Microsoft to expand the Excel row limitation.
Browse more Questions and Answers on AS/400 and Microsoft Windows.
Looking for relevant AS/400 Whitepapers? Visit the Search400.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Popers | Jan 18 2008 3:02PM GMT
The limitation seems to be on iSeries transfer side.. It will not import all rows.
