Records limited when downloading from AS400 to Excel

15 pts.
Tags:
AS/400
AS/400 Records
Exporting AS/400 to Excel
iSeries FTP
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
ASKED: April 4, 2011  1:53 PM
UPDATED: April 12, 2011  10:52 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    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 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
    125,585 pointsBadges:
    report
  • Worksalot
    Thanks! I was able to download to csv and then put the data into an excel format.
    15 pointsBadges:
    report
  • Koohiisan
    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
    5,020 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following