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
Tasks
How to: Export Data to New Files
How to: Export a Quantity or Range of Records
How to: Export Records That Match Conditions
How to: Control the Record Export Process
How to: Export Text Files
How to: Export Numeric or Currency Values