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

  1. From the File menu, choose Export.

  2. Enter the source table and destination file information.

  3. Choose Options.

  4. Choose For to build an expression in the Expression Builder dialog box.


    You do not need to include the FOR command in the expression. For example, type = "Canada" to export only Canadian data.

  5. Choose OK.

    Visual FoxPro evaluates all of the records and exports those that match the condition in the expression.

See Also

© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic