Export Dialog Box

Dialog Box Options

Type

Specifies the type of file to export. Select a file type from the list.

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

Allows 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)	`COPY TO FileName TYPE DIF`
DBASE IV (DBF)	`COPY TO FileName FOX2X`
Delimited Text	`COPY TO FileName TYPE DELIMITED`
FoxBASE+ (DBF)	`COPY TO FileName FOXPLUS`
FoxPro for Windows 2.x (DBF)	`COPY TO FileName FOX2X`
Lotus 1-2-3 1-A (WKS)	`COPY TO FileName TYPE WKS`
Lotus 1-2-3 2.x (WK1)	`COPY TO FileName TYPE WK1`
Microsoft Excel 2.0, 3.0, and 4.0 (XLS)	`COPY TO FileName TYPE XLS`
Microsoft Excel 5.0 and 97 (XL8)	`COPY TO FileName TYPE XL8`
MultiPlan 4.01 (MOD)	`COPY TO FileName TYPE MOD`
Symbolic Link Format	`COPY TO FileName TYPE SYLK`
Symphony 1.01 (WRK)	`COPY TO FileName TYPE WRK`
Symphony 1.10 (WR1)	`COPY TO FileName TYPE WR1`
System Data Format (SDF)	`COPY TO FileName TYPE SDF`
Visual FoxPro 5.0 (DBF)	`COPY TO FileName`

For more information, see "Exporting Data" in Chapter 9, Importing and Exporting Data in the User's Guide.