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?

Report message to a moderator

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: 68686
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 23:05:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.