How to: Append Data to Existing Tables
You can add records to the active table from another file. By default, Visual FoxPro adds all of the records and fields to the table. Using Append From options, you can specify fields or select records. For more information about field and record selection, see the sections How to: Select Fields to Append and How to: Select Records to Append.
To append data
Browse the destination table.
From the Table menu, choose Append Records.
In the Type box, enter the format of the source file.
In the From box, enter the name of the source file.
In the To box, make sure the correct table name is showing.
Tip
If the table name is not correct, choose Cancel, and then open the correct destination table. The To box shows the table active at the time you selected the Append From command.
If you want to specify fields or select records to append, choose Options and complete the Options dialog box.
Choose OK.
Visual FoxPro adds the records to the table.
See Also
Tasks
How to: Append Data with the Import Wizard
How to: Select Fields to Append
How to: Select Records to Append