Querying against two data sources/connection strings

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Truncate end of a string 2
News Tim Berners-Lee announces new vision for internet, putting data privacy first 5
Best Way To Store and Retrieve Data? 13
Less Expensive GPUs Are Hiding In External Graphics Docks 0
Performing a Query from SQL Server Against Access? 1
Easy way to copy data from from data source to another? 3
Connection string, avoiding the use of ODBC 9
Access 2007 corrupts record source SQL string 5

Back
Top