Share via


Process of Exporting Data

You can export data from your Visual FoxPro tables to text files, spreadsheets, or tables used in other applications. The exporting process requires a source table and the destination's file type and name. If you want, you can select which fields and record to export. You can use the new file in any application that supports the file type you select.

Choosing a File Type to Export

The following table lists the file types you can export from Visual FoxPro:

File type File extension Description
Tabs delimited txt A text file with a tab separating each field.
Comma delimited txt A text file with a comma separating each field.
Spaces delimited txt A text file with one space separating each field.
System Data Format sdf A text file with fixed length records ending with a carriage return and line feed.
Table dbf A Visual FoxPro, FoxPro, FoxBASE+®, dBASE, or Paradox 3.5 or 4.0 table.
Microsoft Excel xls A Microsoft Excel (versions 2.0, 3.0, 4.0, 5.0, and 97) worksheet format. The column cells become fields and rows become records. You can export a maximum of 65,535 rows, which includes one row reserved for the field header.
Lotus 1-2-3 wks
wk1
A Lotus 1-2-3 spreadsheet for releases 1-A, 2.x, and 3.x. The column cells become fields and rows become records.

For more information on exporting, see the COPY TO command.

See Also

Selecting Records to Append | Exporting Data to a New File | Importing and Exporting Data | Exporting a Quantity or Range of Records | Exporting Records That Match a Condition | Controlling the Record Export Process