Thread: MS Query help!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default MS Query help!

Some ways of doing this:
1. Dump both tables to text files. This dump may not have to be the whole
tables.
Then join both text files.
2. Write the Excel sheet to a temp Oracle table and run the query on the 2
Oracle tables.
I don't think it is possible to connect to both the Excel sheet and Oracle
at the same time
and run the query on both.
I probably would move away from MS Query and use ADO.

RBS

"Alexandre Brisebois" wrote in message
oups.com...
I am in need of using excel and MS Query to intersect 2 tables, one in
oracle and one in an excel spread sheet.

I have come up with various work arounds, but none seem to be worth it
unless I know that this is absolutely impossible in normal
circumstances.


how can I have 2 data sources for one join query in MS Query.


best regards,
Alexandre Brisebois