>>
>>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...?
>
>Many thanks,
>
>Gadi Hutt

Gadi,

You can

SELECT * ;
    FROM MyTableWithMessedUpNames ;
    INTO ARRAY laMyArray

SELECT MyDatabaseTableWithGoodNames
APPEND FROM ARRAY laMyArray

This will work as long as the fields are in the correct order and the data types are the same.