EMS Data Import for DB2 is a powerful tool to import data to DB2 tables from MS Excel 97-2007, MS Access, DBF, XML, TXT, CSV, MS Word 2007, RTF, ODF and HTML files.

It provides adjustable import parameters, including source data formats for all the fields and destination DB2 data formats for the selected fields, commit options, number of records to skip, etc.

Data Import for DB2 includes a wizard, which allows you to set all the DB2 import options for different files visually, and a command-line utility to execute import to DB2 database 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
  • Adjustable import parameters for each source file
  • Saving all import parameters set on current wizard session
  • Automatic creation of the table structure
  • Command-line utility to import data using the configuration file
  • Powerful visual options module

In-purchase Benefits

  • FREE One Year of Maintenance already included!
  • FREE software updates and upgrades during Maintenance period!
  • FREE and unlimited Technical Support during Maintenance period!
  • Reasonable pricing for Maintenance renewal – from 35% per Year!
  • Volume discounts when buying two or more copies of one product
  • Cross-selling discounts on related products
  • 30-day money-back guarantee

Product screenshots

Mapping fields
Mapping fields
Setting base data format
Setting base data format
Specifying field data formats
Specifying field data formats
Specifying import mode
Specifying import mode
Setting common options
Setting common options
Defining scripts
Defining scripts

Data Import for DB2

Get started with Data Import for DB2

Download a fully-functional 30-day free trial, and start saving time with your database management today.

Download free trial

Got questions?

If you'd like any help, or have a question about our tools or purchasing options, just get in touch.

Related Products