Export Dialog Box
Lets you export data from Visual FoxPro tables to a text file, spreadsheet, or common table format.
This dialog box appears when you select Export from the File menu.
- Type
Specifies the type of file to export. Select a file type from the list. - To
Specifies the path and name of the destination file. Type the path and name, or click the dialog button to find the destination file. - Text delimiter
Allows you to delimit strings of text in the output file. The default text delimiter is the double-quote (") character. This option only appears if you choose Delimited Text from the Type drop-down list. - Field separator
Makes it possible for you to separate data fields in the output file. The default field separator is the comma (,) character. This option only appears if you choose Delimited Text from the Type drop-down list. - From
Specifies the path and name of the source file. Type the path and name, or click the dialog button to find the source file. - Options
Displays the Export Options dialog box, where you specify which records and fields to export.
The following table shows the file types you can export with this command, and their equivalents that you would type in the Command window.
| File Types | Command Equivalent |
|---|---|
| Data Interchange Format (DIF) | |
| DBASE IV (DBF) | |
| Delimited Text | |
| FoxBASE+ (DBF) | |
| FoxPro for Windows 2.x (DBF) | |
| Lotus 1-2-3 1-A (WKS) | |
| Lotus 1-2-3 2.x (WK1) | |
| Microsoft Excel 2.0, 3.0, and 4.0 (XLS) | |
| MultiPlan 4.01 (MOD) | |
| Symbolic Link Format | |
| Symphony 1.01 (WRK) | |
| Symphony 1.10 (WR1) | |
| System Data Format (SDF) | |
| Visual FoxPro (DBF) | |
See Also
Export Options Dialog Box | Command Window | COPY TO Command | Export Options | EXPORT Command | Import Dialog Box | The Process of Exporting Data