+---------------------------------+
|           APPEND FROM           |
+---------------------------------+
APPEND FROM <file> | ?
        [FIELDS <field list>]
        [FOR <expL>]
        [TYPE] [DELIMITED [WITH TAB
        | WITH <delimiter>
        | WITH BLANK]
        | DIF | FW2 | MOD | PDOX
        | RPD | SDF | SYLK
        | WK1 | WK3 | WKS | WR1
        | WRK | XLS ]

-----------------------------------
Adds records to end of database from another file.
-----------------------------------

The file is assumed to be a FoxPro database file with a .DBF extension.
If the file you want to APPEND FROM is a database file and does not have
a .DBF extension, you must specify its extension.  If the file is a not
a FoxPro database you must specify the TYPE of file you will be
appending from.

If you append from a FoxPro database, the database you append from may
be open in another work area.  You may also append from a database that
isn't open but is available on disk.

If you include the ? clause instead of specifying an explicit database
file, the Open File dialog appears so you can choose a database to
APPEND FROM.

If the file you are appending from does not have the usual default file
extension for that type of file, you must include the file's non-default
extension.  For example, Lotus 1-2-3 revision 2.x spreadsheets normally
have a .WK1 file extension.  If the spreadsheet if you are appending
from has an extension other than the expected .WK1 be sure to include
the different extension in file.

Clauses
-------

FIELDS <field list>
        Specifies fields that data is appended to.

FOR <expL>
        Appends new record for each record in file for which <expL> is true.

TYPE
        One of following types must be specified:

DELIMITED [WITH TAB
        | WITH <delimiter>
        | WITH BLANK]
                ASCII text file in which each record ends with carriage return and
line feed.

DIF
        Data Interchange Format used by VisiCalc.

FW2
         Framework II files.

MOD
        Microsoft's Multiplan version 4.01.

PDOX
        Borland's Paradox version 3.5 database files.

RPD
        RapidFile version 1.2.

SDF
        System Data Format file - ASCII text file in which records have a fixed
length and end with a carriage return and a line feed.

SYLK
        SYmbolic LinK interchange format used by Microsoft's MultiPlan.

WK1
        Lotus 1-2-3 spreadsheet revision 2.x.

WK3
        Lotus 1-2-3 spreadsheet revision 3.x.

WKS
        Lotus 1-2-3 spreadsheet revision 1-A.

WR1
        Lotus Symphony spreadsheet versions 1.1 or 1.2.

WRK
        Lotus Symphony spreadsheet version 1.0.

XLS
        Microsoft Excel version 2.0.

+---------------------------------+
|             Example             |
+---------------------------------+
In this example, CUSTOMER database is opened, its structure is copied to
file called BACKUP and BACKUP is opened.  FoxPro then appends all
records from CUSTOMER database with STATE of 'OH'.  These records are
then copied to new DELIMITED file called TEMP.

USE customer
COPY STRUCTURE TO backup
USE backup
APPEND FROM customer FOR state = 'OH'
COPY TO temp TYPE DELIMITED
APPEND FROM temp TYPE DELIMITED

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

See Also:  COPY FILE, COPY TO, IMPORT, EXPORT, SET DATE

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