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
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???
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
Messages: 24268
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:



Excel can log into Oracle DB using ODBC & issue SQL directly against Oracle DB

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
Messages: 160
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 Nov 24 20:46:13 CST 2015

Total time taken to generate the page: 0.13944 seconds