Import data from MS Excel, MS Access, DBF, TXT, CSV, XML files to Oracle tables.

Publisher:	EMS Database Management Solutions, Inc
Downloads:	3905
Software Type:	Shareware, 95.00
File Size:	6.62M
OS:	Windows All
Update Date:	20 October, 2010

EMS Data Import for Oracle is a powerful tool to import data to Oracle 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 Oracle data formats for the selected fields, commit options, number of records to skip, etc. Data Import for Oracle includes a wizard, which allows you to set all the Oracle import options for different files visually, and a command-line utility to execute import to Oracle 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