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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Importing and exporting data » Importing data » Import tools

 

Using the Interactive SQL Import Wizard

The Interactive SQL Import Wizard lets you choose a source and format, and a destination table, for the data. You can import data from TEXT and FIXED format files. You can choose to import this data into an existing table, or you can use the wizard to create and configure a completely 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
Examples

This example shows you how to import data using the Interactive SQL Import Wizard.

To import data (Interactive SQL Data menu)

  1. In Interactive SQL, from the Data menu choose Import.

  2. Follow the instructions in the wizard.

This example adds data about an employee to the Employees table of the SQL Anywhere sample database.

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, from the Data menu choose 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(,) and 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'

The following example shows you how to add a table from an UltraLite database to a SQL Anywhere database.

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, from the Data menu choose Import.

  3. Select In A Database and click Next.

  4. From the Database Type list choose SQL Anywhere

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

  5. Select Customers and click Next.

  6. Select In A New Table, type dba and SQLAnyCustomers, for the Owner and Table Name respectively, and then click Import.

  7. Click Close.

  8. View the generated SQL statement; from the SQL menu, choose 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