Import Excel file into Oracle

Question

I have an Excel file that I need to import into an (new) Oracle table. What is the best way to do this?

Answer 1

Could this help?

http://oracleebusinesssuite.wordpress.com/2007/06/27/import-of-an-excel-or-any-other-file-external-data-into-oracle/

http://www.dba-oracle.com/oracle_tips_excel_spreadsheet.htm

Answer 2

The simplest (technically) way is to export the content as a CSV and use SQL * Loader to import it into the table. This link refers to the documentation for SQL * Loader, which explains how to write a SQL * loader management file.

CSV, OLE VBA . VBA (shell) SQL * Loader, .

Answer 3

http://www.sharewareconnection.com/import-table-from-excel-for-oracle.htm

Answer 4

, Excel ODBC, , .

CSV Oracle APEX CSV.

Answer 5

If you need to perform any checks or cross-references to data, I suggest using an entity relationship manager such as Talend, etc. You can write scripts to do such things, but the tool can make it a little less painful.