Get single ADO Recordset from multiple Access Databases

[Guest]

Hi:

I'm currently using an embedded MS Query to populate a temporary
spreadsheet, then using the resulting rows to populate other spreadsheets,
then removing the temp sheet. I would rather use an ADO recordset to
accomplish the same thing and not have to manipulate a temp sheet.

Problem: The embedded query links two separate Access databases and uses
tables from each in a single Join SQL statement. I've not been able to set
this up using ADO connections, and have found nothing on the forum addressing
this specific situation. Can it be done?

Thanks in advance!

Greg

 

[Dave Patrick]

The example by Steve Brown should get you pointed in the right direction.

http://www.interaktonline.com/Produ.../Joining+tables+grom+different+databases.html

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

 

[Dave Patrick]

I don't see enough to know for sure and I don't have time to test tonight
but try something like this. I might have your DB's and or columns mixed up.


Select MRP.Item, MRP.Desc
FROM MRP
JOIN IMAST IN 'P:\Chicago\Production\Masterdb.mdb' ON
(MRP.Item = INMAST.Item)

The connection string opens Plant2.mdb

--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect