| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Querying 2 databases with one query string
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Web Query Help... | Excel Discussion (Misc queries) | |||
| "Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
| Excel Database Query String Too Long | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
