You'll have to create another table with fields in required order and append data to it.

>Is there a way in VFP7.0 to reorder the fields of a table? I cannot do it during creation of the table, it has to be done once the table has been created and data has been put in it.
>
>TIA!