Share via


Exporting 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

  1. From the File menu, choose Export.
  2. In the Type box, enter the destination file type.
  3. In the To box, enter the destination file name.
  4. In the From box, enter the source file name.
  5. If you want to select fields or records to export, choose Options and complete the Export Options dialog box.
  6. Choose OK.

Selecting Fields to Export

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

  1. From the File menu, choose Export.
  2. In the Export dialog box, enter the destination file type and name.
  3. In the From box, enter the source file name.
  4. Choose Options.
  5. Choose Fields and select the fields from the Field Picker dialog box.
  6. Choose OK.

Selecting Records To Export

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

The Process of Exporting Data | Exporting a Quantity or Range of Records | Importing and Exporting Data | Exporting Records That Match a Condition | Controlling the Record Export Process | Exporting Text Files