How to: Export Records That Match Conditions
If the records you want to export are not sequential within the table, you can build a logical expression that specifies the selection criteria a record must meet to be exported. For example, you can choose to export all records with a particular value in a field.
To enter criteria for exporting records
From the File menu, choose Export.
Enter the source table and destination file information.
Choose Options.
Choose For to build an expression in the Expression Builder dialog box.
Note
You do not need to include the FOR command in the expression. For example, type customer.country = "Canada" to export only Canadian data.
Choose OK.
Visual FoxPro evaluates all of the records and exports those that match the condition in the expression.
See Also
Tasks
How to: Export Data to New Files
How to: Export a Quantity or Range of Records
How to: Control the Record Export Process
How to: Export Numeric or Currency Values