EMS Data Import for Oracle

EMS Data Import for Oracle is a powerful tool to import your data quickly from MS Access, MS Excel, DBF, XML, TXT and CSV files to Oracle database tables.

Features: You need to import data quite often into existing databases.The volume of data may be so big and the need for import may be so often that tools help quite a bit.EMS Data Import for Oracle is a tool to import your data quickly from various sources to Oracle database tables. The tool allows these various ways to import data thereby facilitating the logistics. 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 wizard like interface helps keep the operations quite simple.

You can import data to one or several tables or views from different databases. Some important modes of import Insert All, Insert New, Insert or Update etc. are available. It also has a command line operation mode. One could use the same to schedule imports based on predetermined parameter settings.This utility thus can ease the work of a database administrator quite a bit by making the data import easier.

Overall: Nice and useful utility that makes data import easier.

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