MS Query help!

  • Thread starter Alexandre Brisebois
  • Start date
A

Alexandre Brisebois

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
 
R

RB Smissaert

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
 
A

Alexandre Brisebois

your input was greatly apreciated, I am unfortunately stuck with ms
query :S
 

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

Pivot table causing buffer overflow 4
ms query editor question 2
help to understand 'querytable' 1
Using data from cells in a Query to a MS Access Database 2
Query from Excel to Access - Passing Parameters? 8
MS Query problem 2
Excel & MS Query caused compile errors 14
group/sum in ms query 1

Top