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
 

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

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Connecting to SQL Server DB in Windows 7 1
Connection string to Access 2007 0
Connection issue 5
Synchronization problems while moving folders to new email 1
Straw Man: data validation against a secured SQL Server db over a VPN tunnel 12
Use of Virtual Machine 4

Top