>Hi all,
>
>I'm adding a routine to my new VFP6 system that will import data from the old FPD2.5 system. But I need to add a few new fields to some of the tables in the new system, and would also like to change the names of others. For example:


In addition to ALTER TABLE, since you're importing data in the first place, you can do what you want with SQL SELECT. It makes renaming fields a breeze and you can add new empty fields, too.

Tamar