Import data with the Import Wizard

Use the Interactive SQL Import Wizard to select a source, format, and destination table for the data. You can import data from TEXT and FIXED format files. You can import data into an existing table or a new table. You can also use the Import Wizard to import data between:

  • databases of different types, such as between a SQL Anywhere database and an UltraLite database.

  • databases of different versions (as long as you have an ODBC driver for each database), such as between a SQL Anywhere version 11.0.0 database and a SQL Anywhere version 10.0.0 database.

Use the Interactive SQL 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

To import data

  1. In Interactive SQL, choose Data » Import.

  2. Follow the instructions in the Import Wizard.

To import data from a file into the SQL Anywhere sample database

  1. Create and save a text file named import.txt with the following values (on a single line): 

    100,500,'Chan','Julia',100,'300 Royal Drive',
'Springfield','OR','USA','97015','6175553985',
'A','017239033',55700,'1984-09-29',,'1968-05-05',
1,1,0,'F'

  2. In Interactive SQL, choose Data » Import.

  3. Select In A Text File and click Next.

  4. In the File Name field, type import.txt.

  5. Select In An Existing Table.

  6. Select Employees and click Next.

  7. In the Field Separator list, select Comma(,). Click Next.

  8. Click Import.

  9. Click Close.

    The SQL statement created by the wizard is stored in the command history when the import finishes.

    You can view the generated SQL statement; from the SQL menu, choose Previous SQL.

    The IMPORT statement generated by the Import Wizard appears in the SQL Statements pane: 

    --  Generated by the Import Wizard
INPUT INTO "GROUPO"."Employees" from 'C:\\Tobedeleted\\import.txt' 
FORMAT TEXT ESCAPES ON ESCAPE CHARACTER '\\' DELIMITED BY ',' ENCODING 'Cp1252'
To import data from the SQL Anywhere sample database into an UltraLite database

  1. Connect to an UltraLite database, such as, C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples\UltraLite\CustDB\custdb.udb.

  2. In Interactive SQL, choose Data » Import.

  3. Click In A Database. Click Next.

  4. In the Database Type list, choose SQL Anywhere

  5. On the Identification tab, click ODBC Data Source Name and then type SQL Anywhere 11 Demo. Click Next.

  6. In the Table Name list, select Customers. Click Next.

  7. Click In A New Table.

  8. In the Owner field, type dba.

  9. In the Table Name field, type SQLAnyCustomers.

  10. Click Import.

  11. Click Close.

  12. To view the generated SQL statement, choose SQL » Previous SQL.

    The IMPORT statement created and used by the Import Wizard appears in the SQL Statements pane. 

    --  Generated by the Import Wizard
INPUT USING 'DSN=SQL Anywhere 11 Demo;CON=''''' 
FROM "GROUPO.Customers" INTO "dba"."SQLAnyCustomers" 
CREATE TABLE ON
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1