Also Mark if you whant to get everything from live to test then why not copy the all files DBC, DCT, DCX, DBF, CDX, FPT.

>Thanks Alexandra
>
>My problem is that my databases have the same name.
>
>This is the brick wall I keep walking into:(
>
>
>>Hi Mark you can do the following:
>>

>>OPEN DATABASE livedatabase
>>OPEN DATABASE testdatabase
>>use testdatabase!mytable IN 0 ALIAS testtable
>>SELECT testtable
>>COPY TO mytable DATABASE livedatabase WITH CDX
>>CLOSE DATA ALL
>>

>>>I often have to work with 2 DBCs with the same name.
>>>For example my test database and my live database.
>>>
>>>If I want to zap the tables in my test DBC and append into them from the live DBC I have to use the full path to the live table.
>>>
>>>Is there someway to set an alias to DBC different from its name?