Home » RDBMS Server » Server Utilities » Reading data from excel using PL/SQL (10g 10.2.0.2)
icon4.gif  Reading data from excel using PL/SQL [message #284936] Sun, 02 December 2007 23:16 Go to next message
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
Re: Reading data from excel using PL/SQL [message #284939 is a reply to message #284936] Sun, 02 December 2007 23:21 Go to previous messageGo to next message
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.
Re: Reading data from excel using PL/SQL [message #284961 is a reply to message #284936] Mon, 03 December 2007 00:28 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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
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:
  


Current Time: Tue Dec 24 23:18:12 CST 2024