Home » RDBMS Server » Server Administration » load data from excell sheet into oracle table
load data from excell sheet into oracle table [message #250982] Thu, 12 July 2007 02:08 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear all ,

i want to create a stored procedure which will b used to load data from excell sheet into oracle table .
Can we do it?
how to do it?
Re: load data from excell sheet into oracle table [message #250984 is a reply to message #250982] Thu, 12 July 2007 02:17 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The standard is to save your excel sheet in CSV file and use it through an external table.

Regards
Michel
Previous Topic: Resizing of Redologs
Next Topic: ORA-error stack
Goto Forum:
  


Current Time: Sun Dec 04 04:57:56 CST 2016

Total time taken to generate the page: 0.04405 seconds