Records limited when downloading from AS400 to Excel
When downloading from AS400 to excel, my records are limited to 16383. I can't find the place on Iseries FTP Version 5 release 2 to stop it from limiting the records. Please help.
Software/Hardware used:
ISeries FTP version 5, release 2
Software/Hardware used:
ISeries FTP version 5, release 2
ASKED:
April 4, 2011 1:53 PM
UPDATED:
April 12, 2011 10:52 PM
RELATED QUESTIONS
- How to recieve a excel file via AS2 running on iSeries
- File transfer from V5R4 to V4R5
- How do I disable the query timeout property?
- Add In function in Excel 2010 to download file from iSeries v7.1 exceeding limit, is there something we need to do to up the limit of records from 64K
- Data Transfer from AS400 to excel
Answer Wiki:
Try ftp'ng to a .csv file then bring into Excel to see if same number of records.
You can open the CSV file in Wordpad to see if more than 16,000+ records.
To see all answers submitted to the Answer Wiki: View Answer History.
When downloading from AS400 to excel…
What is your PC operating system? What version of Excel are you using?
I can’t find the place on Iseries http://FTP...
This is unrelated to FTP which has no limits on number of records. This tends to be a limit of various Excel releases.
But Excel isn’t exactly intended to be a file editor. It’s a spreadsheet program. Loading tens of thousands of database rows into Excel wasn’t quite what Microsoft intended early on. The limit has, however, been increased over time.
Tom
Thanks! I was able to download to csv and then put the data into an excel format.
In some cases where the users we have demand to open large csv files in Excel, I have installed OpenOffice (now LibreOffice) for them. It maxes out at 1,048,576 rows, which far exceeds older versions of Excel. It’s free, and can be easily configured to not interfere with their normal Excel work if they need to run them both.
http://www.libreoffice.org/download