Im updating some old systems here to VFP 5.0 (from 123 for DOS and FP2.5) and most of the data is not to be reused. Based on that, I started from scratch, the existing work at best acceptable - worthy of redoing anyway.

However it would be nice if I could copy the customers records (which are just adderesses) from the old table to the new one that I have (re)created.

The obvious way would be just to do a little program with a
DO WHILE !EOF (or whatever, in VFP)
then copying all the required fields, incrementing the old table's pointer, and creating a blank record in the new.

Is this (method) a good idea? Are there any tools that would let me point and click my way to victory? :)