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 data is an administrative task that involves reading data into your database as a bulk operation. Use SQL Anywhere to:

  • import entire tables or portions of tables from text files

  • import data from a variable

  • import several tables consecutively by automating the import procedure with a script

  • insert or add data into tables

  • replace data in tables

  • create a table before the import or during the import

  • load data from a file on a client computer

  • transfer files between SQL Anywhere and Adaptive Server Enterprise using the BCP format clause

If you are trying to create an entirely new database, consider loading the data using LOAD TABLE for the best performance.

 See also

Performance tips for importing data
Importing data with the Import Wizard
Data import with the INPUT statement
Data import with the LOAD TABLE statement
Data import with the INSERT statement
Data import with the MERGE statement
Tips on importing data with proxy tables
Conversion errors during import
Importing tables (Interactive SQL Import Wizard)
Importing tables (SQL)
Table structures for import
Merging different table structures