Download EMS Data Import for DB2 3.7.0.44144

EMS Data Import for DB2 is a powerful tool to import your data quickly from MS Excel, MS Access, DBF, TXT and CSV files to DB2 tables. DB2 Data Import includes a wizard, which allows you to set all the import options for different files visually.

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
Whats new in version 3.7.0.44144:

• Import rate is increased due to use of multithreading.
• Data Import for PostgreSQL. The possibility to choose schema to create a new table is implemented.
• Data Import for PostgreSQL. For server versions 8.1 or higher it is possible to get the list of databases from postgres database.
• XML. Added the possibility of manual and automated identification of the type of the imported XML-file.
• Now log contains information about the string number where the error occurred.
• When importing from several files their logs are located at different tabs, while the main log contains general information about these processes.
• DBF. Wrong identification of Integer type fields. Fixed now.
• Data Import for SQL Server. "Keep identity" option did not work. Fixed now.
• DBF. Data Import for MySQL. National characters were imported incorrectly. Fixed now.
• yyyy-mm-ddThh:nn:ss format was recognized incorrectly. Fixed now.
• HTML. When importing from HTML file with the links the application froze. Fixed now.
• Data Impor...


Requirements:
Pentium 300; 32 MB RAM; Possibility to connect to some local or remote DB2 server; IBM DB2 client software installed; IBM DB2 client software installed
Operating system:
Windows 8, Windows 7, Windows Vista, Windows XP, Windows 2000, Windows 98
Limitations:
Expires in 30 days; Importing only 20 rows.
Release notes:
Major Update