Excel add-in for data transfer limited to 16,500 rows

[Guest.Visitor]

We frequently use Excel?s addin file transfer capability to download information from our AS/400 into Excel spreadsheets. However, our downloads always cutoff at approx. 16,500 records regardless of how many records exist in the file on the As/400. Can you give us any insight as to why this occurs?

[Guest.Visitor]

I don't know if this will work in your situation, but I had to build a CSV file in IFS on the 400 then open it with EXCEL. This was maybe EXCEL from about 3-4 years ago; don't remember the version. DAte fields were a problem but are Lilian(1900-01-01). We did have better luck with Crystal REports in this situation. HTH bobh

[Guest.Visitor]

Len, If you haven't done it yet, install the Microsoft Query option from your Office software package. Using this interface, you will be able to directly Query your AS/400 data and download into a spreadsheet. Some benefits of this approach: You can implement a parameterized Query. You can refresh data with the push of a button. You can manipulate the functionality with macro code. (Do a search for Excel for more posts about this subject) Bill

[Guest.Visitor]

See also the thread in this forum titled "file transfer limit on Excell document (James C Percy) " The following information is copied from "http://www.perldoc.com/cpan/Spreadsheet/WriteExcel.html#LIMITATIONS" The following limits are imposed by Excel or the version of the BIFF file has been implemented: Description= Limit (Source) ----------------------------------- ------ ------- Maximum number of chars in a string= 255 (Excel 5) Maximum number of columns= 256 (Excel 5, 97) Maximum number of rows in Excel 5= 16,384 (Excel 5) Maximum number of rows in Excel 97= 65,536 (Excel 97)

[Guest.Visitor]

Thanks All

[Guest.Visitor]

We have just been doing file transfers and creating files, then taking the files into excel to bypass the problem for the time being... until we go to CA express which fixes the problem... we will continue to use this 2 step process Rob