Retrieving Data using ADO

I need help retrieving data using ADO (executing a select statement)
From a SQL Server 2000 database and directly populate a table in a SQL Server Database on a different server. Does anyone have an idea on how to accomplish this task?
Thanks in advance.
RegardsR U Sure U need to do it manually with ADO ?

There are many ways of doing this type of thing|||Yes, I would like to know if anyone has ever accomplish this task using ADO. I need to incorporate the solution of this task into a project I'm working on. Thanks inadvance.

Rgeards