Board index » VB & Database

All times are UTC



 Link external table in MS SQL Server 
Author Message
Erik
#1 / 2
 Link external table in MS SQL Server

Hi to all
anybody could be tell me if it's possible to link external table (ie MS
Access table) into MS SQL Server DB?

If yes what's the right command that I can use.....

Thank you a lot
Erik



Fri, 30 Sep 2005 21:45:40 GMT  
Vlad Vissoultche
#2 / 2
 Link external table in MS SQL Server
use sp_addlinkedserver stored procedure like this (from BOL):

EXEC sp_addlinkedserver




and next one:




check out SQL Server Books Online

</wqw>


Quote:
> Hi to all
> anybody could be tell me if it's possible to link external table (ie MS
> Access table) into MS SQL Server DB?

> If yes what's the right command that I can use.....

> Thank you a lot
> Erik



Mon, 03 Oct 2005 09:08:06 GMT  
 
 Page 1 of 1
  [ 2 post ] 

 Relevant Pages 

1. Link external table in MS SQL Server

2. Access 2000 VBA/SQL - cannot create pseudo-index on linked SQL Server table

3. How can I attach External MS-Access Tables to MS-AccessDatabases

4. How to make a LINK Table in SQL 2000 Like MS Access

5. Editing problem with linked SQL-Server tables

6. Linking Tables to SQL Server

7. Linked SQL Server Table No NT Authentication

8. DNS less Access Linked tables to SQL Server 2000

9. Linking tables from SQL Server

10. Question about linking SQL Server Tables in Access 98

11. Setting primary key for SQL Server linked table

12. Saving embedded word 97 docs in Access db with linked SQL Server tables

  

 
Powered by phpBB® Forum Software