[cbender]

I know there are a lot of posts on this topic out there but I have not found a satisfactory solution so I'm asking for ideas.

I need to transfer data from one database to another. Sometimes the transfer is from SQL Server to Access and other times the transfer would be Access to SQL Server.

This would be a routine transfer of data in several (10 or more depending on the transfer type) different tables and the fields do NOT match so I would like to be able to do this via SQL strings that would be stored either in a file or database and not have to hardcode any field names in code.

I need to be able to do a "not in" query so as not to append records that are already in the target table.

Is there a way to query data using SQL from one data connection to another? Any sample code would be much appreciated.

Thanks
cb