Excel SQL.Request restricts data returned to array
 

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

GTSA wrote:
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

How many columns?

Alan Beban

It's six columns across.

Ben

"Alan Beban" wrote:

GTSA wrote:
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

How many columns?

Alan Beban

Alan,

Just wanted to thank you as the number of columns was the key to this
particular problem. I rearranged my SQL so that I was only returning 4 or 5
columns and no more N/A's returned. If you or anybody else out there knows
the specifics of this limitation I'd be interested to hear it!

Many thanks for your help

Ben

"Alan Beban" wrote:

GTSA wrote:
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

How many columns?

Alan Beban

Ben wrote:
Alan,

Just wanted to thank you as the number of columns was the key to this
particular problem. I rearranged my SQL so that I was only returning 4 or 5
columns and no more N/A's returned. If you or anybody else out there knows
the specifics of this limitation I'd be interested to hear it!

Many thanks for your help

Ben

"Alan Beban" wrote:


GTSA wrote:

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

How many columns?

Alan Beban

As you increase the number of columns, at what point does the problem occur?

Alan Beban