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 972007,
-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
EMS Data Import 2007 for DB2 keywords: ems, ibm, db2, import, tool, data, sql, server, gui, software, database, sqlmanager, excel, access, dbf, txt, csv, development, windows