Sn,

What you describle should work (select * from abc into table qqq DATABASE MyDatabase).

It sounds like somewhere you have a leftover qqq file messing things up, perhaps in another directory. Also, you can USE the DBC file and remove all references to the table. This will allow you to start over. (Please make a backup first!)


>i have amongst others, a table abc in my database xyz. i wish to make a copy of the table abc by:-
>
>set exclusive on
>select * from abc into table qqq
>
>but i get an error message "File qqq already exists as part of a database". table qqq does not exist in the first place.
>
>i also tried:-
>
>set data to xyz
>remove table abc
>
>before i execute the select * command but i have the same result.
>how do i accomplish my mission? ta