Online Documentation for SQL Management Studio for Oracle

Running Data Import


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

 

Data Import for Oracle provides you with an easy-to-use Wizard which guides you through all the steps of data import process: you can set 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, import mode, etc.

Additionally to the GUI version which is implemented in the form of a Wizard application, Data Import for Oracle includes the console version which is intended for running from Windows command line with a template file name used as the execution parameter.

 

To run Data Import for Oracle, click its icon or caption on the Desktop Panel and follow the steps of the Wizard. If necessary, you can click the Arrow-down button to open the menu allowing you to specify a template, and run the wizard/console with the template.

 

To manage configuration files (templates), use the corresponding Manage templates link. In this case you will be redirected to the Template Management section of SQL Studio.

 

Data Manipulation - Running Data Import