Home » RDBMS Server » Server Utilities » Reading data from excel using PL/SQL (10g
icon4.gif  Reading data from excel using PL/SQL [message #284936] Sun, 02 December 2007 23:16 Go to next message
Messages: 55
Registered: November 2006
Location: Mumbai

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.

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
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
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: 63911
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.
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: Sat Oct 22 08:31:14 CDT 2016

Total time taken to generate the page: 0.11849 seconds