Product Info
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
What's new in current version
- 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...
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
Please contact EMS Data Import for DB2 publisher, EMS Database Management Solutions, Inc if you have questions or issues regarding this product.