must specify its extension. If the file is a not a FoxPro table, you must specify the type of file you append from. p> Before you can append from a table created in dBASE IV that contains a memo field, you must first open the table in FoxPro with USE. You are prompted with "Convert MEMO file to FoxPro Format?" Choose Yes. p> If you append from a FoxPro table, the table you append from can be open in another work area. You can also append from a table that isn't open but is available on disk and a shared table opened when SET EXCLUSIVE is OFF. When the table you append from contains records marked for deletion, the records are not marked for deletion after they are appended. br/>
If you include the? clause instead of including a table name, the Open dialog appears so you can choose a table to append from. br/>
Clauses
Specify the name of the file to append from with . If you don't include a file name extension, the default extension. DBF is assumed.
FIELDS
APPEND FROM supports an optional . Data is only appended to the fields specified in the field list.
FOR
The entire source file is appended to the table unless you include the FOR clause. If the FOR clause is included, a new record is appended for each record in the file source for which evaluates to a logical true (. T.). Records are appended until the end of the file is reached. br/>
TYPE
If the file you are appending from isn't a FoxPro table, you must specify the file TYPE. Although you must specify the file type, you need not include the key word TYPE. You can append from a wide variety of different file types including DELIMITED ASCII text files in which you can specify a field delimiter.
If the file you are appending from doesn't have the usual default file extension for that type of file, the source file name must include the file's extension. For example, Microsoft Excel spreadsheets normally have an. XLS file name extension. If the spreadsheet you are appending from has an extension other than the expected. XLS, be sure to specify the extension.
Caution When appending from a spreadsheet, the data in the spreadsheet must be stored in a row major order rather than a column major order. This allows the appended spreadsheet data to match the table structure.
DELIMITED [WITH TAB | WITH | WITH BLANK]
A DELIMITED file is an ASCII text file in which each record ends with a carriage return and line feed. Field contents are by default assumed to be separated from each other by commas, and character field values ​​to be additionally delimited by double quotation marks. For example:
"Smith", 9999999, "TELEPHONE"
The DELIMITED WITH TAB option can be used to specify files which contain fields separ...
