Querying against two data sources/connection strings

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting rid of connection strings? 1
Connection string, avoiding the use of ODBC 9
ADP querying all rows in design view 16
Manage ODBC 2
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Newbie question: query over two data sources 4
SQL Server connection 17
Use of Virtual Machine 4

Top