OraFAQ Forum: Client Tools » excel & oracle database

Home » SQL & PL/SQL » Client Tools » excel & oracle database (Oracle 10g, Win7)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

excel & oracle database [message #564177]

Tue, 21 August 2012 22:11

nischalinn
Messages: 80
Registered: May 2012
Location: nepal

Member

I am using SQLTools 1.5 for writing Oracle SQL scripts.

I have to import data from excel file to oracle database. HOw
can I do it? Also how can I export data from Oracle database to Excel file?

what is the script to do this???

Report message to a moderator

Re: excel & oracle database [message #564178 is a reply to message #564177]

Tue, 21 August 2012 22:37

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

http://www.orafaq.com/wiki/index.php?title=Special%3ASearch&search=excel&go=Go

http://www.lmgtfy.com/?q=import+data+from+excel+file+to+oracle+database
Excel can log into Oracle DB using ODBC & issue SQL directly against Oracle DB

http://www.lmgtfy.com/?q=export+data+from+Oracle+database+to+Excel+file
Oracle can be programmed to write Comma Separated Value (*csv) file & XML file;
which Excel can import, read, or injest.

Report message to a moderator

Re: excel & oracle database [message #564221 is a reply to message #564178]

Wed, 22 August 2012 03:24

Flyby
Messages: 120
Registered: March 2011
Location: Belgium

Senior Member

sqldeveloper also has an export to csv option

Report message to a moderator

Previous Topic:	remove spaces (4 Merged)
Next Topic:	Query stored Unicode URDU Data through SQL*PLUS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 12:32:24 CDT 2013

Total time taken to generate the page: 0.09965 seconds