OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Import to Oracle from Excel .XLS files- it there a way?

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Import to Oracle from Excel .XLS files- it there a way?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Import to Oracle from Excel .XLS files- it there a way? [message #127961]

Thu, 14 July 2005 07:04

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.

Report message to a moderator

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

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.

Report message to a moderator

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

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.

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator