>I meed to copy existing data, a FPW 2.6 application to an equivalent VFP application. Some of the new tables have a few additional fields, otherwise the field names are the same. What is the best way to copy the data from the old application to the new one. Some issues.
>
>What I am consider, after backing up data, is to
>
>1. Zap tables in new system
>2. Use SQL Select to create an intermediate file (allows some house cleaning) from old tables.
>3. Append data from step 2 in to new tables.
>
>Is this a reasonable approach?

I created a NewProg.PRG where I scanned each 2.6 table I needed brought ove. For each record I did an INSERT INTO NEWTABLE ... Of course, this was a major rewrite and many of data structures changed, the accounting practice changed, etc. Otherwise, your approach is very reasonable. In step 2 you can select into a Cursor instead of a table, then APPEND FROM dbf("MyCursor")