OraFAQ Forum: Server Utilities » Reading data from excel using PL/SQL

Home » RDBMS Server » Server Utilities » Reading data from excel using PL/SQL (10g 10.2.0.2)

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

Reading data from excel using PL/SQL [message #284936]

Sun, 02 December 2007 23:16

atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai

Member

Hi,

I need to read the data from an excel from certain path and copy it in to a oracle table using PL/SQL.

I would like to know is there any Oracle Utility for the same and the method to implement it.

please provide me with some sample code.

Thanks
Atul

Report message to a moderator

Re: Reading data from excel using PL/SQL [message #284939 is a reply to message #284936]

Sun, 02 December 2007 23:21

rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India

Senior Member

Google for UTL_FILE / External tables as first step.
SQL LOADER search will also help you (Not PL/SQL routine)

Thumbs Up

Rajuvan.

Report message to a moderator

Re: Reading data from excel using PL/SQL [message #284961 is a reply to message #284936]

Mon, 03 December 2007 00:28

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Just use the Search button above and type "excel" in the field.
This is asked almost every week.
Closed.
/forum/fa/448/0/

Regards
Michel

Report message to a moderator

Previous Topic:	Load datas from Excel sheet to oracle table (merged)
Next Topic:	load xml file/data in oracle table through sql*loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jun 28 16:44:38 CDT 2024