Excel SQL.Request restricts data returned to array

G

GTSA

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
 
A

Alan Beban

GTSA said:
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
Click to expand...

How many columns?

Alan Beban
 
B

Ben

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
 
A

Alan Beban

Ben said:
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

:
Click to expand...
As you increase the number of columns, at what point does the problem occur?

Alan Beban
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX return multiple columns 1
Data returned from Oracle to Excel via SQL.REQUEST 0
function to retrieve array name 6
Can the Excel RTD function return an array (It does on Bloomberg) 0
CSE with function returning an array? 2
Using INDEX function to return array row. 1
Return to next row in first column when entering data in Excel 3
Return an array of data based on range of date 3

Top