Live Chat with Sales rep.

We will be happy to answer any sales or upgrade questions that you have. We can chat online or you can call us.
Toll-free for U.S. & Canada: 1-866-SQL-4-YOU (1-866-775-4968)

| Learn More

Data Import for DB2 News

12/03/2009
EMS Data Import version 3.3 released
Added the possibility to choose encodings, the support of date formats expanded, some visual changes, and much more…

02/04/2009
EMS Data Import version 3.2 released
SQL Server 2008 and PostgreSQL 8.3 support added, the possibility to create tables for imported data, and much more…

10/02/2007
Data Import v.3.1 released
Data import from the text of XML documents embedded nodes, as well as auto-recognition of columns and autofill of table fields added, resizable Wizard window and more...

03/07/2007
Data Import v.3.0 released
New “Native” import method and Unicode support are added (for SQL Server, MySQL, PostgreSQL), highly increased performance, new formats supporting and much more…

12/26/2005
EMS Product Trials CD - all EMS software on one CD
Get all EMS product FREE trials on one low-cost CD with an automatically launched user-friendly shell.

08/18/2005
Data Export and Data Import Utilities 2.1 released!
Added Portuguese language support, decreased processor loading while executing long operations and more...

News Subscribe | More News |

XML content. Requires RSS support to view.

EMS Data Import for DB2

Print this Page

Overview

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 20% per Year!
Volume discounts when buying two or more copies of one product
Cross-selling discounts on related products

Product Screenshots

User-friendly wizard interface
Step 2 - Selecting source files

Available Versions

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

Download | Buy options