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 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.
Visual FoxPro evaluates all of the records and exports those that match the condition in the expression.