Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Import to Oracle from Excel .XLS files- it there a way?
Import to Oracle from Excel .XLS files- it there a way? [message #127961] Thu, 14 July 2005 07:04 Go to next message
AlexL
Messages: 2
Registered: June 2005
Junior Member
Hello!

Is there a way to import Excel .XLS files to Oracle DB (through Html DB) automatically, not manually?

Thank you in advance.
Re: Import to Oracle from Excel .XLS files- it there a way? [message #128207 is a reply to message #127961] Fri, 15 July 2005 12:30 Go to previous messageGo to next message
jvalvert
Messages: 2
Registered: July 2005
Location: Guatemala
Junior Member
Axel, the best way to import xls table to oracle bdd is to using a bdd tool like TOAD or from MS Access. Toad is specialy designed to manage Oracle BDD's and you only should use the Import Data Wizard. If you use MS Access, you must configure an ODBC connection to the Oracle BDD, and then load the xls like an table (Access uses an generic odbc for xls data) and you are ready to import data to Oracle BDD.
Re: Import to Oracle from Excel .XLS files- it there a way? [message #146432 is a reply to message #128207] Thu, 10 November 2005 06:59 Go to previous messageGo to next message
Amitjsheth
Messages: 1
Registered: November 2005
Junior Member
Can we directly import the data from excel to oracle.

Can I use PL/Sql Developer to import the data in oracle from excel sheet.
Re: Import to Oracle from Excel .XLS files- it there a way? [message #146757 is a reply to message #146432] Sun, 13 November 2005 19:52 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Q2) If you save the spreadsheet as a csv file then you can use utl_file to read it (as long as the database machine can access to the directory into which you saved the file).

Depending on the version of Oracle database you are using you could define a file as an external table and just treat it as though it was another table.

David
Re: Import to Oracle from Excel .XLS files- it there a way? [message #268337 is a reply to message #146757] Tue, 18 September 2007 04:16 Go to previous messageGo to next message
probalc
Messages: 1
Registered: September 2007
Junior Member
can you please expand a little,a code snippet will help.

I cannot use utl_file as I do not have access to end user directory.
Re: Import to Oracle from Excel .XLS files- it there a way? [message #268452 is a reply to message #268337] Tue, 18 September 2007 13:09 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
http://orafaq.com/node/848

http://orafaq.com/faq/can_one_read_write_files_from_pl_sql
Previous Topic: Accessing external API (COM Objects)
Next Topic: Converting .csv into oracle database
Goto Forum:
  


Current Time: Sun Dec 04 08:39:16 CST 2016

Total time taken to generate the page: 0.07774 seconds