+---------------------------------+
|             COPY TO             |
+---------------------------------+
COPY TO <file>
        [FIELDS <field list>]
        [<scope>] [FOR <expL1>]
        [WHILE <expL2>]
        [[WITH] CDX]
        | [[WITH] PRODUCTION]
        [NOOPTIMIZE]
        [TYPE] [FOXPLUS | DIF | MOD
        | SDF | SYLK | WK1 | WKS
        | WR1 | WRK | XLS | DELIMITED
        [WITH <delimiter>
        | WITH BLANK | WITH TAB]]

-----------------------------------
Copies data from selected database to file.
-----------------------------------

<file>
        File where data is copied.

FIELDS <field list>
        Specifies which fields are copied to new file.

<scope>
        Copies only records that fall in range of records specified by scope.

FOR <expL1>
        Copies only records that satisfy logical condition <expL1>.

WHILE <expL2>
        Copies records to new file for as long as logical expression <expL2>
evaluates to true.

[WITH] CDX | [WITH] PRODUCTION
        Creates identical structural index for new database.

NOOPTIMIZE
        Disables Rushmore.

TYPE
        Specifies file type.

FOXPLUS
        Creates database that may be used in FoxBASE+.

DIF
        Copies file to DIF (Data Interchange Format, used by VisiCalc) file.

MOD
        Copies file to Microsoft's Multiplan version 4.01 MOD format.

SDF
        Copies file to an SDF (System Data Format) file.

SYLK
        Copies files to a SYmbolic LinK interchange format (used by Microsoft's
MultiPlan).

WK1
        Copies files to a new Lotus 1-2-3 revision 2.x spreadsheet.

WKS
        Copies file to a Lotus 1-2-3 revision 1-A spreadsheet.

WR1
        Copies file to Lotus Symphony spreadsheet revision 1.10.

WRK
        Copies file to a Lotus Symphony spreadsheet revision 1.0.

XLS
        Copies file to Microsoft Excel spreadsheet version 2.

DELIMITED [WITH <delimiter> | WITH BLANK | WITH TAB]
        ASCII text file in which each record ends with carriage return and line
feed.  Fields are normally separated by commas, and character fields are
additionally delimited by double quotation marks.  For example:

        "Smith", 9999999, "TELEPHONE"

        The DELIMITED WITH <delimiter> option may be used to indicate that
character fields will be delimited by a character other than a double
quotation mark.  The DELIMITED WITH BLANK or the DELIMITED WITH TAB
options may be used to create files which contain fields separated by a
space or a tab instead of commas.  Unless you specify otherwise a .TXT
file extension will be assigned to all newly created DELIMITED files.

+---------------------------------+
|         Program Example         |
+---------------------------------+
USE customer
COPY NEXT 3 TO temp TYPE DELIMITED

In this example, the CUSTOMER database is opened and the next three
records are copied to a new DELIMITED data file called TEMP.TXT.

-----------------------------------

See Also:  APPEND FROM, COPY FILE, EXPORT, IMPORT, SET OPTIMIZE

-----------------------------------