APPEND Subcommand (SAVE TRANSLATE command)
TYPE=ODBC
For TYPE=ODBC, APPEND appends rows (cases) to an existing
database table after type and variable name validations. There must be a matching column in the
table for each IBM® SPSS® Statistics variable. If a column that can correctly store a variable is not found, a failure is returned. If
the table contains more columns than the number of IBM SPSS Statistics variables, the
command still stores the data in the table. The variable names and column names must match exactly.
A variable can be stored in a column as long as the column type is a type that can store values of
the variable type. A column of any numeric type (short integer, integer, float, double, etc.) is
valid for a numeric variable, and a column of any character type is valid for a string variable.
Note: APPEND can only add rows to a table, not columns. If you want to add
columns (fields) to a database table, see the SQL subcommand.
TYPE=XLS
For TYPE=XLS, APPEND can append a new sheet to an existing
file.
APPENDis valid only forVERSION=12.- A sheet name must be specified on the
EXCELOPTIONSsubcommand.