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.
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.
In Interactive SQL, click Data » Import.
Click In a text file, then click Next.
In the File name field, click Browse to add the file.
Click In a new table and fill in the Table name.
For your text file, specify the way the file is read and then click Next.
Make any changes to the column names and data types and then click Import.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|