Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Interactive SQL Online Help Interactive SQL Version 16.0 » Interactive SQL Help » Interactive SQL dialog boxes

Import wizard

Use the Import Wizard to select a source, format, and destination table for the data. You can import data from text files and fix format files. You can import data into an existing table or a new table.

The Import Wizard allows you to import data between:

Use the Import Wizard when you:

You must be a database administrator to run the Import Wizard.

To import data from an ODBC data source (for example, Excel):

  1. In Interactive SQL, click Data | Import. Interactive SQL displays the Import Wizard.

  2. Select In a database from the screen titled Where do you want to save the results?.

  3. Click Next

  4. Select the Indentification screen.

  5. Select ODBC Data Source name from the Select an ODBC data source pane.

  6. Enter the name of the data source in the ODBC Data Source name drop-down list, or use the Browse button to open the Data Source Names dialog.

  7. Click Next.

  8. Select the name of the table you want to import from the Table Name list.

  9. Click Next.

  10. Select In a new table from the Where do you wnat to save the data? screen

  11. Select the appropriate Database and Owner from the drop-down lists, and enter the new table name in the Table Name box.

  12. Click Import.