Question:
I want to Transfer records from one Database table to other Database table but through VB. I can’t write a query such as I can for SQL Server:

Insert into Try.ABCSelect * fromTry1.XYZ

Is there any simple way, similar to the code above, to achieve this, apart from opening one resultset & then writing insert statement.

Answer:
You’ve already got the best approach for doing database data transfer from one database to another with the SQL Statement.

It does give you the flexibility to modify data on the way from one database to the other. There’s really no other way to do it automatically.