OraFAQ Forum: Client Tools » excel & oracle database

Home » Other » Client Tools » excel & oracle database (Oracle 10g, Win7)

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

excel & oracle database [message #564177]

Tue, 21 August 2012 22:11

nischalinn
Messages: 118
Registered: May 2012
Location: nepal

Senior 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: 26766
Registered: January 2009
Location: SoCal

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: 188
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 Sep 30 12:18:25 CDT 2023