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
Size
5.71 MB
License
Shareware
Price
95.00 USD
Category
Software Development / Database & SQL
Operating System
Win95,Win98,WinME,WinNT 4.x,WinXP,Windows2000,Windows2003,Windows Media Center Edition 2005,Windows Vista Starter,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate,Windows Vista Home Basic x64,Windows Vista Home Premium x64,Windows Vista Business x64,Windows Vista Enterprise x64,Windows Vista Ultimate x64
Program system requirements: Pentium 300; 32 MB RAM; Possibility to connect to some local or remote DB2 server; IBM DB2 client software installed
New in this version:-Importing data from the text of XML documents embedded nodes
-Ability to explicitly specify the data file for the console version using the -datafile= parameter
-Auto-recognition of columns and autofill of table fields for TXT files
-Other minor improvements and bugfixes.
1)
2)
3)
4)
5)
6)
7)
1)
2)
3)
4)
5)
6)
7)