Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging two och more recordsets
Hi,
I want to join data from 2 different databases in one table and then put the merged data in a spreadsheet. I use 2 recordsets to get the data: RS1 contains the following data: SELECT CustomerID, Name, Description FROM Table X (in DB1) RS2 contains the following data: SELECT CustomerID, Adress, Description FROM Table Y (in DB2) I now want to join RS1 with RS2 and put the result in RS3. I suspect you could do something like this(?): RS3.RecordSource= SELECT RS1!Name, RS2!Adress FROM RS1, RS2 WHERE RS1.CustomerID=RS2.CustomerID but I donīt know exacly how to do this. Kind regards! Peter Osswald |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging two och more recordsets
You need to do the join in the sql statement that creates the records set -
rather than creating two recordsets, create one recordset doing the join in that sql statement. -- Regards, Tom Ogilvy "PO" <po wrote in message ... Hi, I want to join data from 2 different databases in one table and then put the merged data in a spreadsheet. I use 2 recordsets to get the data: RS1 contains the following data: SELECT CustomerID, Name, Description FROM Table X (in DB1) RS2 contains the following data: SELECT CustomerID, Adress, Description FROM Table Y (in DB2) I now want to join RS1 with RS2 and put the result in RS3. I suspect you could do something like this(?): RS3.RecordSource= SELECT RS1!Name, RS2!Adress FROM RS1, RS2 WHERE RS1.CustomerID=RS2.CustomerID but I donīt know exacly how to do this. Kind regards! Peter Osswald |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging two och more recordsets
1. Is it possible to join two tables from two different databases (one
Oracle database and one MS Access database) in one singel select statement?? 2. Is it imposible to accomplish what I discribed below, that is, joining two recordsets into one? Regards, Peter O "Tom Ogilvy" wrote in message ... You need to do the join in the sql statement that creates the records set - rather than creating two recordsets, create one recordset doing the join in that sql statement. -- Regards, Tom Ogilvy "PO" <po wrote in message ... Hi, I want to join data from 2 different databases in one table and then put the merged data in a spreadsheet. I use 2 recordsets to get the data: RS1 contains the following data: SELECT CustomerID, Name, Description FROM Table X (in DB1) RS2 contains the following data: SELECT CustomerID, Adress, Description FROM Table Y (in DB2) I now want to join RS1 with RS2 and put the result in RS3. I suspect you could do something like this(?): RS3.RecordSource= SELECT RS1!Name, RS2!Adress FROM RS1, RS2 WHERE RS1.CustomerID=RS2.CustomerID but I donīt know exacly how to do this. Kind regards! Peter Osswald |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging two och more recordsets
PO,
can you create a linked table in either one of the main databases? then you can use 1 sql engine to do the work for you. i dont see it happening the way you describe. keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "PO" <po wrote: 1. Is it possible to join two tables from two different databases (one Oracle database and one MS Access database) in one singel select statement?? 2. Is it imposible to accomplish what I discribed below, that is, joining two recordsets into one? Regards, Peter O "Tom Ogilvy" wrote in message ... You need to do the join in the sql statement that creates the records set - rather than creating two recordsets, create one recordset doing the join in that sql statement. -- Regards, Tom Ogilvy |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging two och more recordsets
No, you couldn't do the single SQL since the recordsets belong to different
parents. I don't know ADO well enough to say whether you could put each result in a cursor and treat the cursor as two tables that could be joined, producing a third recordset. But, you could put each rs on a worksheet, then built a combined table/join using the Vlookup function - if your looking for an immediate solution. -- Regards, Tom Ogilvy "PO" <po wrote in message ... 1. Is it possible to join two tables from two different databases (one Oracle database and one MS Access database) in one singel select statement?? 2. Is it imposible to accomplish what I discribed below, that is, joining two recordsets into one? Regards, Peter O "Tom Ogilvy" wrote in message ... You need to do the join in the sql statement that creates the records set - rather than creating two recordsets, create one recordset doing the join in that sql statement. -- Regards, Tom Ogilvy "PO" <po wrote in message ... Hi, I want to join data from 2 different databases in one table and then put the merged data in a spreadsheet. I use 2 recordsets to get the data: RS1 contains the following data: SELECT CustomerID, Name, Description FROM Table X (in DB1) RS2 contains the following data: SELECT CustomerID, Adress, Description FROM Table Y (in DB2) I now want to join RS1 with RS2 and put the result in RS3. I suspect you could do something like this(?): RS3.RecordSource= SELECT RS1!Name, RS2!Adress FROM RS1, RS2 WHERE RS1.CustomerID=RS2.CustomerID but I donīt know exacly how to do this. Kind regards! Peter Osswald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem displaying recordsets in Excel Format | Excel Discussion (Misc queries) | |||
When merging information not merging correctly | Excel Worksheet Functions | |||
Merging | Excel Discussion (Misc queries) | |||
Sorting, Merging, and Re-merging | Excel Worksheet Functions | |||
ADO Recordsets | Excel Programming |