|
Importing data is an administrative task that involves reading data into your database as a bulk operation. SQL Anywhere lets you:
import entire tables or portions of tables from ASCII files
import entire tables or portions of tables from other database formats, such as DBASE or EXCEL
import a number of 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
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.
For more information about unloading and reloading complete databases, see Rebuilding databases.
Import considerations
Performance tips for importing data
Import tools
Handling conversion errors during import
Importing tables