<div>
I'd say linked server or just linked table, if You have msaccess it's as simple as create table-&gt; liked table-&gt;path.<br />
insert values into table from @linked_table
</div>


<div>
<div class="content wysiwyg-content">
I need to write &nbsp;a sql server statement that will insert data into a table from a table that is on a different physical server. &nbsp;How can I do this?
</div>
</div>


I need to write  a sql server statement that will insert data into a table from a table that is on a different physical server.  How can I do this?

Insert SQL Data from Different Server

Adobe Acrobat is a family of application software and Web services developed by Adobe Systems to view, create, manipulate, print and manage files in Portable Document Format (PDF). The family comprises Acrobat Reader (formerly Adobe Reader), Acrobat (formerly Acrobat Exchange) and Acrobat.com. The commercial proprietary Acrobat, available for Microsoft Windows and OS X only, can also create, edit, convert, digitally sign, encrypt, export and publish PDF files.

Adobe Acrobat

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.