What are the best and/or easiest methods for importing data from Excel (.xls) into an Oracle database?
Please, kindly clarify with any code examples you can.
1
-
2An idea is to use the IDE. Toad and SQL Developer has import excel option. Just right click the table and select import option.Florin Ghita– Florin Ghita2012-04-24 10:22:15 +00:00Commented Apr 24, 2012 at 10:22
Add a comment
|
2 Answers
One of the most common way for importing data from Excel to Oracle Db is to export the contents as a CSV and use SQL*Loader to import it into the table.
The easiest way however, is to use an IDE as mentioned in the comments like TOAD or SQL Developer (which is my favourite Oracle DBM tool).
See this article for more alternative ways.
1 Comment
Brian
Oracle XE has a browser based wizard (apex) that will do everything as well - including creating lookup tables and surrogate keys with the sequence and necessary trigger.
you can also use perl to read the excel spreadsheet and insert the values from the spreadsheet into the db. Take a look at DBD::Oracle and Spreadsheet::ParseExcel in CPAN.
