Thanks J
I may try this for some tables but other tables I think will lose some information about the table that is stored in the DBC such as long field names etc:(
>>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?
>
>You could also delete the tables from the test DBC and add them from the live like so:
>
Select * From d:\myLive\myDBC!myTable
> Into DBF myTable
> Database d:\myTest\myDBC
>This from the test DBC directory. HTH