Choose your SQL server:
AnySQL
MySQL
MS SQL Server
Oracle
PostgreSQL
SQLite
Firebird
SQL Anywhere
DB2
MaxDB

Subscribe to our newsletter
Partners

DB2 Data Wizard online Help

Prev  Return to chapter overview Next 

Data Import Wizard

Data Import wizard for DB2 is a powerful tool for importing data to DB2 tables from files of the following formats: MS Excel, MS Access, XML, DBF, TXT and CSV.

 

Consider the list of Data Import Wizard distinguishing features:

 

Data import into DB2 tables from different databases.
 
The ability to import data from the following available formats: MS Excel, MS Access, XML, DBF, TXT and CSV.
 
Easy adjustments of the source file columns and the destination table fields.
 
Full customization of the import process for each imported file including data formats for all or selected fields, commit options, number of rows to skip and records to import, etc.
 
The ability to define the key columns for the table and select whether to skip, update or delete the records if their keys value match the imported ones.

 

 

See the following topics to learn more about Data Import Wizard:

 

 



Prev  Return to chapter overview Next