dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Insert a specific recordset from a Table into an external Table using TSQL

  1. #1
    Anouar Guest

    Insert a specific recordset from a Table into an external Table using TSQL


    How can I Insert a recordset from a local table (SQL server Data Base) into
    an external table (Access Data base) using TSQL.
    With Standard SQL the INSERT command has an option to specify an external
    data base but with TSQL this command has not this option.

    Think you.

  2. #2
    Michael Levy Guest

    Re: Insert a specific recordset from a Table into an external Table using TSQL

    The simple and sparse answer is to look at Linked Servers in SQL Server
    7.0/2000. You can create a linked server to an Access database.

    Checkout the SQL Server BOL and the August SQL Server Mag.

    -Mike
    --
    Michael Levy MCSD, MCDBA, MCT
    Consultant
    GA Sullivan
    michaell@gasullivan.com




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center