Choosing How to Export the Data

After you select the data source, you indicate the manner in which you want to export the data.

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. See the topic Replacing Values in Existing Fields for more information.
• 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. See the topic Adding New Fields for more information. 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. See the topic Appending New Records (Cases) for more information.
• 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 (for example, primary keys, data types) is lost. See the topic Creating a New Table or Replacing a Table for more information.
• 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. See the topic Creating a New Table or Replacing a Table for more information.