Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> import from .xls worksheet to oracle database
Denisa
post Mar 19 2008, 04:20 AM
Post #1


Member
**

Group: Members
Posts: 29
Joined: 15-January 07
Member No.: 6,524



Hi!

I want to import data from excel worksheet to some oracle tables.
how can I do it with pl/sql code ? or through sql developer tool.
my database is 10g.

thanks

denisa
Go to the top of the page
 
+Quote Post
burleson
post Mar 19 2008, 08:58 AM
Post #2


Advanced Member
***

Group: Members
Posts: 11,810
Joined: 26-January 04
Member No.: 13



Hi Denisa,

>> I want to import data from excel worksheet to some oracle tables.

Try XML:

http://www.remote-dba.cc/t_easy_html_db_xm...dsheet_data.htm

Have you considered using external tables?

http://www.dba-oracle.com/art_ext_tabs_spreadsheet.htm


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
mutale
post Mar 20 2008, 01:05 AM
Post #3


Advanced Member
***

Group: Members
Posts: 53
Joined: 15-December 06
Member No.: 6,160



QUOTE (Denisa @ Mar 19 2008, 11:21 AM) *
Hi!

I want to import data from excel worksheet to some oracle tables.
how can I do it with pl/sql code ? or through sql developer tool.
my database is 10g.

thanks

denisa


Hi Denisa
Try saving the excel sheet in csv format and user sql loader (data pump).

Mutale


--------------------
Mwamba Mutale, OCP
Oracle Database Administrator
www.mwambamutale.com
Go to the top of the page
 
+Quote Post
Yasir
post Mar 20 2008, 01:54 AM
Post #4


Member
**

Group: Members
Posts: 13
Joined: 27-December 07
Member No.: 15,479



Hi Denisa,

There are many ways to import data from Excel file into Oracle tables, two methods are already on you are notice board of this topic using "Exceldb tool" and "SQL Loader". You can also import the data from excel file using Oracle Developer forms at runtime. If you need any further help, you may please reply me on yasir_pisces@hotmail.com.


With Regards

Yasir
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd December 2014 - 01:16 AM