download25.com

Your free TOP 25 download source!

Featured Software

 IconActive Query Builder Delphi VCL Edition
True two-way visual SQL Query Builder component for Delphi and C++ Builder
aqb_.zip

 IconEMS Data Export for SQL Server
Program to export data from MS SQL databases into the most popular formats.
msexport.zip

 IconEMS Data Import for InterBase/Firebird
Import data from MS Excel, MS Access, DBF, TXT, CSV and XML files to IB table
ibimport.zip

 IconEMS Data Export 2005 for InterBase/Firebird
Program to export data from IB/FB databases into the most popular formats.
ibexport.zip

 IconEMS Data Export 2005 for MySQL
Program to export data from MySQL databases into the most popular formats.
mysqlexport.zip

EMS Data Import for DB2 3.3

Import data from MS Excel, MS Access, DBF, TXT, CSV and XML files to DB2 tables.
Publisher: EMS Database Management Solutions, Inc
Category: Databases & Networks
Version: 3.3
License: shareware
Cost: 95$
Size: 6.46 MB
Updated: 26 Jan 2016
Review
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


Changelog:
Version: 3.3(18 Feb 2010)
Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table.
Now the user can choose the necessary encoding, including UTF8, when importing from DBF files.
Other improvements and bugfixes.
Version: 3.2(25 Mar 2009)
- Added the possibility to create separate tables for each source data file; to choose the file character set (None, OEM, ANSI) when importing data from DBF files.
- It is now possible to specify the source data charset when importing TXT and CSV files.
and much more...
Version: 3.1(02 Oct 2007)
-Importing data from the text of XML documents embedded nodes
-Ability to explicitly specify the data file for the console version using the -datafile=source file name parameter
-Auto-recognition of columns and autofill of table fields for TXT files
-Other minor improvements and bugfixes.
Version: 3.0(23 Jan 2007)
- The new ?Native? method of import is added which includes two algorithms ? Single Commands and Batch Insert.
- Import from new formats.
- Utility source code significantly optimized, work speed increased.
- Other improvements and bugfixes.
Version: 2.2(30 Oct 2006)
- The ability to import data from VisualFoxPro DBF format added.
- The amount of memory consumed is significantly decreased when importing large files.
- Other improvements and bug-fixes.
Version: 2.1

download (db2import.zip - 6.46 MB)