Hi,
i think you are doing something different. Your query will just insert record of same table into itself (duplication!) Since
da = New OleDb.OleDbDataAdapter(strSQL, cnTo)
can use only one connection at a time.
if this was sql ,i have used database name in front of table name to achive this.like
INSERT INTO [DBNAME1].[tablename] SELECT * FROM [DBNAME2].[tablename]