Import your data from MS Access, MS Excel and other popular formats to database tables via user-friendly wizard interface. 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.

EMS Data Import allows you to efficiently import data from most popular formats into database tables on supported DBMS. The utility comes in separate editions for each of the most widely used DBMS servers (SQL Server, ORACLE, MySQL, PostgreSQL, InterBase/Firebird, DB2) and uses native access to the server, which ensures maximum productivity during import process and reduces the time required to import a large amount of information.

EMS Data Import for Oracle Features:
1. Import from 10 most popular formats: MS Excel 97-2007, MS Access, XML, DBF, TXT, CSV, MS Word 2007, OpenDocument Format and HTML
2. Importing data to one or several tables or views from different databases
3. A number of import modes - Insert All, Insert New, Insert or Update, and others
4. Adjustable import parameters for each source file
5. Saving all import parameters set on current wizard session
6. Automatic creation of the table structure
7. Command-line utility to import data using the configuration file
8. Powerful visual options module

EMS Data Import offers a variety of possible settings for the import parameters like import mode, possible transformation of data types during import process, skipping the unnecessary information and many others. All settings can then be saved into a configuration file for future use. The program's interface is intuitive and clean; based on the Wizard system it lends itself to the import task.

Limitations:
* Imports 20% rows of the source data file.

The license of this software is Free Trial Software, the price is $14.00, you can free download and get a free trial.