I can use the following code to create a conection string:

sConnect = "Provider=SQLOLEDB;" & _
"Data Source=Ben;" & _
"Initial Catalog=Northwind;" & _
"Integrated Security=SSPI"

...then execute a SQL statement to return the query results to my workbook.

Is it possible though, to store the results of a query that joins 2 tables
contaned in separate SQL databases?

Thanks

Ben