copy sql table to other sql database

Submitted by sal21 on
Have one sqlserver1 with database1 and table1, and one sqlserver2 with database2. How to copy table1 into database2, via vb6 classic?