>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! Ü

Although this is the VB forum, you could probably make this easier with a VFP program that just removes the table from one database and adds it to the second database. In this way there is no data transfer, probably just a file copy and some field renaming.

If this is not feasible then you are stuck with using a recordset for the transfer. HTH,