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:

Databases of different types, such as between a SQL Anywhere database and an Adaptive Server database
Databases from different versions (as long as you have an ODBC driver for each database) – for example, between an Adaptive Server 12.0 database and a Adaptive Server 15.7 database

Use the Import Wizard when you:

Want to create a table at the same time you import the data
Prefer using a point-and click interface to import data in a format other than text

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

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

In Interactive SQL, click Data | Import. Interactive SQL displays the Import Wizard.
Select In a database from the screen titled Where do you want to save the results?.
Click Next
Select the Indentification screen.
Select ODBC Data Source name from the Select an ODBC data source pane.
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.
Click Next.
Select the name of the table you want to import from the Table Name list.
Click Next.
Select In a new table from the Where do you wnat to save the data? screen
Select the appropriate Database and Owner from the drop-down lists, and enter the new table name in the Table Name box.
Click Import.