What I understand is,
you want to copy data from One Database Table to another Database Table,
If this is right then you can use following query.
Con_DB.Execute "INSERT INTO DB_ONE.dbo.TABLE_ONE ([Field_One],[Field_Two]) " & _
"SELECT [Field_One],[Field_Two] " & _
"From DB_TWO.dbo.Table_ONE"