>vfp 3.0
>
>i am copying information from fields from one database
>to another database and field names are different.
>
>what is the best way to accomplish this? copy fields
>to arrays and then use replace command?
>
>do i need to open both databases at the same time to
>do this?
>
>Thanks and have a good day.
>
>Becky

IN addition to the other ideas, here's what I do:

SELECT SomeField AS newName, Somefield2 AS NewName2 INTO CURSOR Whatever

SELECT NewTable
APPEND FROM DBF("Whatever")