>>
>>Gad,
>>Select into table ...
>>Free table ...
>>and copy to fox2x are ones that come to mind but be carefull there might be things when you do that. ie: Long field names.
>>Cetin
>
>
>Well as you thought Cetin, I do need the long names
>( I need 15 chars, had I known about the 10 char's limitation, i would have reduced the fields names to begin with, but now it is too late... )
>
>So, what I need is to copy the data from the free tables I created into a database table. The fields that got "shortened names" are not copied when I use APPEND FROM, is there a way doing this...?

Well, create a new database and preserve long names, or copy type fox2x and lose them. Not too much choice. If the first case suits you, here's how it goes:

create database NewDBC
use oldDBC!TableToCopy
copy to NewTable of NewDbc next 0 with cdx

The next 0 clause will copy structure only - if you need the data as well, then omit this clause (this is one of the few multi-record commands in Fox which doesn't default to current record but to all instead). The 'with cdx' is nice if you want to copy both the structure and indexes.

If you must go the fox2x route, you may want some control over the shortening of the names.

Select LongNamedField1 as shrtnumfld1, ;
  ..., LongNamedFieldN as shrtnumfldN ;
  from TableToCopy into cursor temp

copy to NewTable type fox2x