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

Report message to a moderator

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: 68665
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.
/forum/fa/448/0/
Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jun 28 16:39:09 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.