Say i have two Access databases:
I'm within Excel i'm using VBA:
I can connect to one database by using:
Set objConnection = New ADODB.Connection
objConnection.Mode = adModeRead
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..