EMS Data Import for DB2 is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, TXT, CSV and XML files to DB2 tables. It provides adjustable import parameters, including: source data formats for all the fields and destination data formats for the selected fields, commit options, number of records to skip, etc. DB2 Data Import includes a wizard, which allows you to set all the import options for different files visually, and a command-line utility to execute import in one-touch.

Key Features:

- Import from 10 most popular formats: MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument Format and HTML

- Importing data to one or several tables or views from different databases

- A number of import modes - Insert All, Insert New, Insert or Update, and others

- UNICODE support

- Adjustable import parameters for each source file

- Saving all import parameters set on current wizard session

- Command-line utility to import data using the configuration file

- Powerful visual options module

- User-friendly wizard interface