Hi,

I would like to extract data from Oracle to Excel. I have created and tested the connection using ADO. When I run the query in Oracle SQL Developer client, it runs fine. However the same query run in Excel, does not provide any data. Here is the query:
Code:
select decode(b.location,'Bangkok','Thailand','Beijing','China','China WSBB','China','Colombo','Sri Lanka','Colombo','Sri Lanka', 'DBIA', 'Singapore','DSI Tokyo','Japan','Guangzhou','China','Ho Chi Minh','Vietnam','Hong Kong','HONGKONG', 'Hong Kong LON','HONGKONG','Jakarta','Indonesia','Karachi','Pakistan','Kuala 
Lumpur','Malaysia','London','Malaysia', 'Manila','Philippines','Mumbai','India','Seoul','South Korea','Shanghai','China','Singapore','Singapore', 'Singapore local','Singapore','Sydney','ANZ','Sydney GMF','ANZ','Taipei','Taiwan','Tokyo 
Consolidated','Japan', 'Tokyo Sales','Japan',b.location), count(t.systemid) 
from rms_owner.trade t, book b
where t.systemid > 209240000
and t.systemid < 209250000
and t.book in (
select name from book where location in ('Bangkok','Beijing','China 
WSBB','Colombo','Colombo','DBIA','DSI Tokyo','Guangzhou',
'Ho Chi Minh','Hong Kong','Hong Kong LON','Jakarta','Karachi','Kuala 
Lumpur','Manila','Mumbai','Seoul','Shanghai','Singapore',
'Singapore local','Sydney','Sydney GMF','Taipei','Tokyo Consolidated','Tokyo Sales')
AND status = 'Open' AND bookgroupYN = 'N'   
)
and t.lastupdated between '01-JUN-2009' and '30-JUN-2009'
and t.datecreated between '01-JUN-2009' and '30-JUN-2009'
and t.tradetable  not in ( 'FXCASHBALANCE','CASHBALANCE')
and t.action !='Roll'
and b.name = t.book
group by b.location
Why is there a problem?