I am working on a program that reads information from a number of FoxPro tables via ODBC and places results into a Access database. I am able to pull the needed records from the FoxPro tables into either a recordset or query object, but I am not sure the best way to then insert these records into the second database. Any code ideas? Thanks.

Jay D Zimmerman