0

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.

Brian Tompsett - 汤莱恩
  • 5,753
  • 72
  • 57
  • 129
ernest tuscano
  • 1
  • 1
  • 2
    An 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 Apr 24 '12 at 10:22

2 Answers2

1

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.

Korhan Ozturk
  • 11,148
  • 6
  • 36
  • 49
  • 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. – Brian Apr 24 '12 at 14:26
0

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.

MichaelN
  • 1,734
  • 11
  • 6