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