How to copy data from a DB to other DB in different server

[RH+]

I have to query one table and insert the result in a table on another database in another server
The query is "select ID, name from Table"
The other table exists and have the same fields.
How can I do this?
thanks!