>That seems to be the solution, but I am having some trouble. I have an open connection to the databse I want the records placed in. When I try to construct the SQL statement to execute against my connection object I get in trouble. What should I be doing if I have the Access conneciton open and want to move data from the SQL server to this database? I am at a roadblock.

Hi,

May you post the code you've already written, so I could look into it?