>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

USE FROMDB
USE TODB IN 0

SELECT FROMDB
SCAN
m.TODB.fieldname1 = FROMDB.fieldname1
...
INSERT INTO TODB FROM MEMVAR

ENDSCAN

HTH