Share via


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)

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

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 (DBF)

COPY TO FileName

See Also

Concepts

Exporting Data

Reference

Export Options Dialog Box

Command Window (Visual FoxPro)

COPY TO Command

EXPORT Command

Import Dialog Box

Other Resources

Dialog Boxes (Visual FoxPro)