Home » SQL & PL/SQL » SQL & PL/SQL » copy data from excel (Oracle 9i)
copy data from excel [message #324301] Sun, 01 June 2008 21:41 Go to next message
rajboopin
Messages: 7
Registered: December 2007
Location: INDIA
Junior Member
hi,

Can anyone suggest me how to load datas from excel sheet into

oracle database. Please explain me with detail description in

step by step.
bye
Re: copy data from excel [message #324303 is a reply to message #324301] Sun, 01 June 2008 22:03 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
use MS ACCESS
Re: copy data from excel [message #324308 is a reply to message #324301] Sun, 01 June 2008 23:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you search BEFORE posting?
We have this question more than once per month.

Regards
Michel
Re: copy data from excel [message #324451 is a reply to message #324308] Mon, 02 June 2008 09:16 Go to previous messageGo to next message
jramya
Messages: 42
Registered: April 2008
Member
In toad,we can use the Import Option to load excel data into oracle table.
Table structure have to be created in oracle prior to import.
Re: copy data from excel [message #324536 is a reply to message #324301] Tue, 03 June 2008 00:46 Go to previous messageGo to next message
DEATHZQ
Messages: 1
Registered: April 2007
Junior Member
use PL/SQL
Re: copy data from excel [message #324537 is a reply to message #324301] Tue, 03 June 2008 00:49 Go to previous message
ajay2301
Messages: 2
Registered: June 2008
Junior Member
create a insert script in excel itself using concatenate function. Razz
Previous Topic: Store Image in 10g db
Next Topic: Unable to capture the parameter values from a PL/SQL procedure
Goto Forum:
  


Current Time: Fri Dec 09 17:37:59 CST 2016

Total time taken to generate the page: 0.14683 seconds