All geek questions in one place

SQL Server 2005 Querying Multiple Access Databases?

Is there a way to force SQL Server 2005 to query 3 or more separate Access databases (each returning 1 record) in a single SQL statement?

+4
source share
4 answers

Yes, but you will need to create a Linked Server instance for each Access database. See here for details on creating Linked Server instances on SQL Server 2005 prior to MS Access .

Once you have these capabilities, you can query SQL Server and transfer the queries to the appropriate Access databases based on the use of Linked Server instance notation when specifying tables in SQL Server queries.

+6
source

What you want is a Linked server for each of the Access databases.

+1
source

Remember that in the 64-bit version of SQL 2005, you will not be prompting for the current version of Access or Excel through linked servers any time soon.

+1
source

Yes, configure them as linked servers using sp_addlinkedserver .

0
source

Source: https://habr.com/ru/post/1299684/

More articles:


All Articles