EMS Data Import for Oracle imports data from various file formats including MS Excel, Access, XML, TXT, CSV, and more to Oracle tables. It enables users to effortlessly migrate data and supports a wide range of file formats, including Microsoft Office files and HTML.
One of the key features is that the software includes a wizard that allows users to set all the Oracle import options for different files visually. Users also have the option of using a command-line utility to execute imports to the Oracle database in one-touch. The adjustable import parameters for each source file, as well as the option to save all import parameters set on the current wizard session, allows users maximum flexibility.
With this software, users can import data to one or several tables/views from different databases with ease. A number of import modes are available, including Insert All, Insert New, Insert or Update, and others. Additionally, the software automatically creates the table structure, saving time and effort for users.
Overall, this is a powerful tool that is suitable for users with various levels of database experience. The visual options module ensures that users are not intimidated by the software's full feature set, while more experienced users also have the option of using the command-line utility for more advanced imports.
Version 3.3:
Added the possibility to automatically form fields when importing from TXT, CSV and XML formats to a new table.
Now the user can choose the necessary encoding, including UTF8, when importing from DBF files.
Other improvements and bugfixes.
Version 3.2:
- Added the possibility to create separate tables for each source data file; to choose the file character set (None, OEM, ANSI) when importing data from DBF files.
- It is now possible to specify the source data charset when importing TXT and CSV files.
and much more...
Version 3.1:
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile= parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version 3.1:
- Importing data from the text of XML documents embedded nodes
- Ability to explicitly specify the data file for the console version using the -datafile= parameter
- Auto-recognition of columns and autofill of table fields for TXT files
- Other minor improvements and bugfixes
Version 3.0:
- The new “Native†method of import is added which includes two algorithms.
- Import from new formats.
- Identity fields support implement.
- Utility source code significantly optimized, work speed increased.
- Other improvements and bugfixes.