You can try something like this.

OPEN DATABASE database1
USE country IN 0 ALIAS ReplaceMe EXCL

OPEN databse database2
USE country IN 0 ALIAS Country
SELECT Country
COPY TO ARRAY aTemp

SELECT ReplaceMe
ZAP
APPEND FROM ARRAY aTemp

don't forget to backup first


>Hi,
>
>Sorry about asking such a silly question - but I'm new to Vfoxpro!
>
>I have two databases, they are basically the same. What I'm trying to do is replace the contents of a table in dbase1 with the contents of a table in dbase2.
>
>To expand on this. Both of the tables are called "country", what I want to do is overwrite the entire contents of the table "country" in dadabase1 with the entire contents of "country" in database2.
>
>What I thought I needed to do was remove the table in the first database and then try to copy the otherone over.
>
>Is this the easiest / best way to proceed? The table structure is the same in both databases
>
>Cheers
>Rob