Nadya,
No problem...I'm eating lunch anyway.
I can't find it documented in VFP help or in Hacker's Guide. Also, I haven't figured out how it handles the DATABASE keyword. If I leave that keyword out, it will prompt me to overwrite an existing file. If I leave it in, I get an error on the second attempt at creating the same file name. However, the new table does not appear to be actually added to the DBC.
You could go with my other solution (the COPY TO command), or take out the DATABASE keyword. Then add the new table to the DBC (if it is not there).
>>Oops...I didn't notice that you weren't using CREATE TABLE.
>>
>>CREATE gives an error of the table you are trying to create already exists in a database...
>
>Hi Steve,
>
>Sorry for bothering you again. Where did you find the description of this command in Help? I just can not. CREATE command Help doesn't show DATABASE keyword, etc.
>
Steve Gibson