>>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? :)
>
>Hi,
>
> Ed is right but if you have already made tables for the new application, I would suggest you to use APPEND FROM....
>
>Bye
>Jayesh

To Jeff (via Jayesh),

And if you have automated your Primary Key function by putting a function call in the default value of the key field, you won't need to worry about duplicate keys while appending. (Nothing worse than getting to the 949,999 record of 950,000 and finding a duplicate key)

Barbara