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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Importing and exporting data » Importing data

 

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 12 database and a SQL Anywhere 11 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 12\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. From the Action dropdown list, choose Connect With An ODBC Data Source.

  6. Click ODBC Data Source Name, and then type in the box below, SQL Anywhere 12 Demo.

  7. Click Next.

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

  9. Click In A New Table.

  10. In the Owner field, type dba.

  11. In the Table Name field, type SQLAnyCustomers.

  12. Click Import.

  13. Click Close.

  14. 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 12 Demo;CON=''''' 
    FROM "GROUPO.Customers" INTO "dba"."SQLAnyCustomers" 
    CREATE TABLE ON