>>
>>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

Gad,
I couldn't see why you need free tables here. Can you elaborate it more.
If it's a must there are tricky ways
Simple ones :
-array copying as Cindy suggested if table is within array limits
-copying to textfile type SDF, delimited if no memo and general is involved
-scatter-gather memvar with creating long memvar names (ie: m.longfieldname = m.longfieldn)
-instead of free table creating a tempoary view and dropping when done
-instead of free table using nofiltered cursor
-Directly appending from with a for clause
etc.
But honestly again I couldn't understand the scenario yet.
Cetin