| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Query help!
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MS Query help!
your input was greatly apreciated, I am unfortunately stuck with ms
query :S RB Smissaert wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
| Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
