Home » SQL & PL/SQL » Client Tools » excel & oracle database (Oracle 10g, Win7)
excel & oracle database [message #564177] Tue, 21 August 2012 22:11 Go to next message
nischalinn
Messages: 117
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???
Re: excel & oracle database [message #564178 is a reply to message #564177] Tue, 21 August 2012 22:37 Go to previous messageGo to next message
BlackSwan
Messages: 22728
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.
Re: excel & oracle database [message #564221 is a reply to message #564178] Wed, 22 August 2012 03:24 Go to previous message
Flyby
Messages: 144
Registered: March 2011
Location: Belgium
Senior Member
sqldeveloper also has an export to csv option
Previous Topic: remove spaces (4 Merged)
Next Topic: Query stored Unicode URDU Data through SQL*PLUS
Goto Forum:
  


Current Time: Tue Sep 02 22:14:11 CDT 2014

Total time taken to generate the page: 0.10368 seconds