Querying against two data sources/connection strings

  • Thread starter Maury Markowitz
  • Start date
M

Maury Markowitz

I have a text file I'd like to access as if it were a database. It has prices
for various commodities. The name of the file changes every day.

I also have a SQL Server, which has a list of the commodities we're
interested in.

I would like to access the text file via a connection string, and then join
it on the data in our SQL server.

Is there a way to do this? It appears queries can have only one connection?

Maury
 
A

Aaron Kempf

keep all your data in SQL Server and then it's easy to join between SQL data
and SQL data
 
Top