Download SPSS Base 15.0 User's Guide

57
Data Files
The following choices are available for exporting data to a database:
„
Replace values in existing fields. Replaces values of selected fields in an existing table with
values from the selected variables in the active dataset. For more information, see Replacing
Values in Existing Fields on p. 60.
„
Add new fields to an existing table. Creates new fields in an existing table that contain the
values of selected variables in the active dataset. For more information, see Adding New
Fields on p. 61. This option is not available for Excel files.
„
Append new records to an existing table. Adds new records (rows) to an existing table
containing the values from cases in the active dataset. For more information, see Appending
New Records (Cases) on p. 62.
„
Drop an existing table and create a new table of the same name. Deletes the specified table
and creates a new table of the same name that contains selected variables from the active
dataset. All information from the original table, including definitions of field properties
(e.g., primary keys, data types) is lost. For more information, see Creating a New Table or
Replacing a Table on p. 63.
„
Create a new table. Creates a new table in the database containing data from selected variables
in the active dataset. The name can be any value that is allowed as a table name by the data
source. The name cannot duplicate the name of an existing table or view in the database. For
more information, see Creating a New Table or Replacing a Table on p. 63.
Selecting a Table
When modifying or replacing a table in the database, you need to select the table to modify or
replace. This panel in the Export to Database Wizard displays a list of tables and views in the
selected database.