pjp3,

What have you tried so far? Just to make sure we are on the same page, your going to have two data sources, one for each MS Access DB, and you want to generate an insert into one database which depends on the results of a SQL statement from the other database? Is this correct so far? If this is correct then why not store the results of the select statement then use the results to generate the insert for the other database?

Hope this helps.

Martin