Choosing an Existing Table to Receive Your Data

The following steps are required when choosing an existing XDB Server table into which you want to insert the imported data.

To choose a table to receive your imported data:

  1. Specify the file whose contents you want to import.
  2. Click the Browse button in the XDB Table Information section on the Import window.

    SQLWizard displays the Open dialog box.

  3. Choose the desired location, AuthID, and table name of the destination table and click OK.

    The selected location, AuthID, and table name appear in the Table field on the Import window. Also, SQLWizard retrieves the table definition from the system catalog and displays it in the Table Definition Grid at the bottom of the Import window.

    Note:


    Catalog Browser button
    Instead of selecting a destination table as described in steps 2 and 3, click the Table tab in the Catalog Browser dialog box, and drag a table name to the Table field on the Import window.

  4. You can now choose whether to append or replace data. If you wish to replace (overwrite) the data that exists in the selected table, click the Replace Data checkbox. Otherwise, new data from the file will be appended to the existing data in the table.
  5. Click the Run button or click the Run command from the Import menu to import the data.

    The status of the import operation is displayed in the status bar across the bottom of the window. When the import completes, this line indicates that the import is complete and lists the number of records imported.