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