Sorry, let me continue

strSQL = " INSERT INTO ["c:\any.mdb"].TableName(Field1, Field2) "
strsql = strSQL & " SELECT FROM Employees(Field1, Firled2) "

cnn.Execute strsql

This works when inserting data into an Access database. Need to try with others.

Jason