How to: Export Data to New Files
You can copy all of the fields and records from your Visual FoxPro table to a new file or you can copy only the fields and records you select.
To export data
From the File menu, choose Export.
In the Type box, enter the destination file type.
In the To box, enter the destination file name.
In the From box, enter the source file name.
If you want to select fields or records to export, choose Options and complete the Export Options dialog box.
Choose OK.
By default, Visual FoxPro exports all of the fields in the source table to the destination file. You can select which fields to export by using the Export Options dialog box.
To select fields to export
From the File menu, choose Export.
In the Export dialog box, enter the destination file type and name.
In the From box, enter the source file name.
Choose Options.
Choose Fields and select the fields from the Field Picker dialog box.
Choose OK.
When you export data, you might want to limit the number of records that are copied to the new file by providing selection criteria. You can:
Choose a scope of records by specifying a quantity or range.
Build a FOR expression that selects records that match a condition.
Build a WHILE expression that selects records until one record is found that does not match a condition.
You can use any combination of these options. The WHILE expression overrides the other criteria.
See Also
Tasks
How to: Export a Quantity or Range of Records
How to: Export Records That Match Conditions
How to: Control the Record Export Process
How to: Export Numeric or Currency Values