I am using SQL Request to interrogate an Oracle 8i database. When I run the
SQL through SQL Plus the query returns 1004 rows of data. When I run it from
Excel 97 it only returns the first 681 rows, and these are fine. The
remaining array rows are populated with N/A's. I have encountered this
problem with different DBs where it has again returned a large part of the
data but not all of it.

Has anyone else encountered this problem? I've trawled Google for ages and
read all the Microsoft info I can find - any help/suggestions would be
greatly appreciated!

Many thanks