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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Importing and Exporting Data » Importing data » Import tools

Using the INPUT statement to import data Next Page

Using the LOAD TABLE statement to import data

The LOAD TABLE statement lets you efficiently import data into an existing table in text/ASCII formats. The LOAD TABLE statement imports one row per line, with values separated by a delimiter.

Use the LOAD TABLE statement when you want to:

For more information, see LOAD TABLE statement.

Impact on the database

Changes are not recorded in the transaction log when the LOAD TABLE statement is used, which makes this statement unusable with SQL Remote or MobiLink remote databases. If you need to recover data using the current transaction log and an older copy of the database, recovery fails if the original data file is no longer present.

The LOAD TABLE statement is considerably faster than the INPUT statement.

The LOAD TABLE statement adds the contents of the file to the existing rows of the table; it does not replace the existing rows in the table.