Greetings!

I have two ODBC connections pointing to two sets of FoxPro tables/database.

Is there an easy way to copy/import records from our old database to the newer one, which have similar fields (renamed field names, modified types, etc...)?

Only thing I can think of is to fetch the required records into a recordset and then insert each record into the new database via a loop, which seems VERY inefficient...

Any better alternatives?

Thanks! Ü