Import data from MS Excel, MS Access, DBF, TXT, CSV and XML files to DB2 tables.
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