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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data import and export » Data import

 

Importing tables (Interactive SQL Import Wizard)

You can use Interactive SQL to import data from a text file, another table in any database, or a shape file, into a table in your database.

Prérequis

You must have the CREATE TABLE privilege to create a table owned by you, or have the CREATE ANY TABLE or CREATE ANY OBJECT system privilege to create a table owned by others.

 Task
  1. In Interactive SQL, click Data » Import.

  2. Click In a text file, then click Next.

  3. In the File name field, click Browse to add the file.

  4. Click In a new table and fill in the Table name.

  5. Click Next.

  6. For your text file, specify the way the file is read and then click Next.

  7. Make any changes to the column names and data types and then click Import.

  8. Click Close.

Résultat

The data is imported into the specified table.