Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Batch Table to Table copy?
Message
From
29/09/1998 09:45:26
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00141901
Message ID:
00141908
Views:
22
>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? :)

That's quite acceptable. Also, you may consider another way: copy old table to new location, rename it, include to new DBC and modify structure to get new table.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform