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

[Anouar]

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.

[Michael Levy]

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