Home » RDBMS Server » Server Utilities » Load datas from Excel sheet to oracle table (merged)
icon4.gif  Load datas from Excel sheet to oracle table (merged) [message #284562] Fri, 30 November 2007 01:23 Go to next message
yesukannan
Messages: 14
Registered: May 2007
Junior Member
hi,
can someone guide to load/import data from Excel sheet to oracle table using PL/SQL or SQL Loader.

regards
Gangadevi
Re: load data from Excel sheet to oracle table using PL/SQL or sql Loader [message #284565 is a reply to message #284562] Fri, 30 November 2007 01:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.
You have to first convert your excel file in csv format.

Also search BEFORE posting, this has been asked many and many times.

Closed.
./fa/448/0/
Regards
Michel
Re: Load datas from Excel sheet to oracle table [message #284566 is a reply to message #284562] Fri, 30 November 2007 01:31 Go to previous message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

http://www.orafaq.com/faqloadr.htm

Kiran
Previous Topic: Data not getting inserted to specified tablespace
Next Topic: Reading data from excel using PL/SQL
Goto Forum:
  


Current Time: Thu Dec 08 20:18:46 CST 2016

Total time taken to generate the page: 0.34096 seconds