Long field names make it through fine with this select statement. Although I'm not sure about other things like default values and such.

>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