Monday, March 26, 2012

Linked tables

Hi,
Does anyone know how i can link tables in an SQL DB to an etxernal database,
just like in MS Access?
--
Many thanks in advance for any assistanceYou don't link tables per se. What you do is to set up the remote server as a "linked Server" Read
more about the concept in Books Online, where you find how to do it with SQL commands as well as
through the GUI.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Marek" <Marek@.discussions.microsoft.com> wrote in message
news:81955741-5D1F-4CDB-8ED5-7764B9A89D0C@.microsoft.com...
> Hi,
> Does anyone know how i can link tables in an SQL DB to an etxernal database,
> just like in MS Access?
> --
> Many thanks in advance for any assistance

No comments:

Post a Comment