Are you using Client Access?

IIRC, the last version of CA that I used only supported 16384 rows when
transfered to excel (xl95 row count).

I'm not sure if CA ever updated that addin for more rows.

I haven't used it in a while, but I think I'd dump the data to an ASCII file and
then open that ASCII file in excel.

Does that ring a bell with you?

StanTheMan wrote:

I converted to EXCEL 2002 and attempting to do file transfer from AS/400
machine. On my previous EXCEL 2000 version, I could read over a maximum of
50,000 records. With EXCEL 2002, I get a message" The data will not fit in
the worksheet" and stores exactly 16,351 records. What do I do to read the
maximum number of records ?

--

Dave Peterson