VB6 and SQL Server : Pulling records

Microsoft SQL Server 2000

I am very new to programming. Can u pls assist.

I have the records in a database( Table 1)(Available on QA Server).
Now I want to write code, to pull those data from Table1 to a different database(Table 2)(Available on Development Server) and Table 2 (which is the records that are pulled) should run every month.ie.it has to be rerun.

Can anyone of u Pls help me with this code by providing syntax?
If u need any more details pls let me know.
Thx in advance.

So far, I have this code:

Dim conn As New ADODB.Connection
Set conn.ConnectionString= "ODBC; Table1 & ";UID=" &
UID & ";PWD=" & PWD
conn.Open

and I do not understand how to rerun this code and whether the above code will work?