<div>
It would be easier to do the join query in either Access database and then, open the join query from Excel.
</div>


It would be easier to do the join query in either Access database and then, open the join query from Excel.

<div>
If you could do this in Access, it would be much simpler - just link both tables, and then you can work with them as needed. Using ADO from Excel, you'd not be able to join two tables from different data sources.
</div>


If you could do this in Access, it would be much simpler - just link both tables, and then you can work with them as needed. Using ADO from Excel, you'd not be able to join two tables from different data sources.

<div>
Create a third database that has these two tables attached to it. &nbsp;Then you can run your join query against this new database. &nbsp;You can create the database and attach tables manually or with ADOX.
</div>


Create a third database that has these two tables attached to it.  Then you can run your join query against this new database.  You can create the database and attach tables manually or with ADOX.

<div>
Sorry for my delay. &nbsp; This solution did it.. THANK YOU!
</div>


Sorry for my delay.   This solution did it.. THANK YOU!

<div>
<div class="content wysiwyg-content">
Hello Everyone<br />
&nbsp; &nbsp;Say i have two Access databases:<br />
&nbsp; &nbsp; &nbsp; &nbsp; Database1.accdb<br />
&nbsp; &nbsp; &nbsp; &nbsp; Database2.accdb<br />
&nbsp; &nbsp;I'm within Excel i'm using VBA:<br />
&nbsp; &nbsp; &nbsp;I can connect to one database by using:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Set objConnection = New ADODB.Connection<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; objConnection.Mode = adModeRead<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; objConnection.Open connectionString<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sqlString = &quot;SELECT * FROM Table1&quot;<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Set objRecordSet = objConnection.Execute(sqlS<wbr />tring)<br />
<br />
&nbsp; however, is it possible to connect to two seperate databases...<br />
&nbsp; to do a join query?<br />
<br />
thanks in advance..
</div>
</div>


Hello Everyone
   Say i have two Access databases:
        Database1.accdb
        Database2.accdb
   I'm within Excel i'm using VBA:
     I can connect to one database by using:

          Set objConnection = New ADODB.Connection
          objConnection.Mode = adModeRead
          objConnection.Open connectionString
         sqlString = "SELECT * FROM Table1"

         Set objRecordSet = objConnection.Execute(sqlString)

  however, is it possible to connect to two seperate databases...
  to do a join query?

thanks in advance..

Query Two Tables in seperate databases

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.