Want to upsert data from Excel file to Oracle ?
Using XlsToOra, you can upsert data from Excel file to Oracle easily and fast, no need to program, just a few mouse clicks!
Here you can download and install XlsToOra.
Upsert data from Excel file to Oracle
Click “Wizard For Importing” at task dialog.
then show the wizard.
1. Open an Excel file.
2. Select a table and config fields.
Set “Load Type” to “Upsert”, choice “Update Key”.
3. Preview data.
4. Upsert.
More about XlsToOra – the tool to import data from Excel file to Oracle