Home » RDBMS Server » Server Utilities » exporting data from oracle to excel worksheet
exporting data from oracle to excel worksheet [message #68961] Thu, 04 October 2001 07:52 Go to next message
milimo munyati
Messages: 1
Registered: October 2001
Junior Member
Hi

Does anybody know how I can export oracle data from oracle database to an excel worksheet. I need to provide a direct interface for a user where they just click a button and they fetch data from oracle to excel.

Thanks in advance

Milimo

----------------------------------------------------------------------
Re: exporting data from oracle to excel worksheet [message #68971 is a reply to message #68961] Fri, 05 October 2001 06:16 Go to previous messageGo to next message
regis
Messages: 2
Registered: October 2001
Junior Member
u can have a look to :
http://www.orafaq.net/faqodbc.htm#EXCELL

I try sql*xl but it doesn't seem to work with my excell version (95... yes i know... not the last youth...)

rgds

----------------------------------------------------------------------
Re: exporting data from oracle to excel worksheet [message #68973 is a reply to message #68961] Fri, 05 October 2001 12:06 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
you can run a query directly from Excel (Data > Get external data > etc using an ODBC connection). Obviously you can link this to a makro and a button.
You can generate output from Oracle too in a formatted way to a flat file which can be loaded into Excel. .csv is the earies, but the below link shows the way to include formatting too.
http://asktom.oracle.com/pls/ask/f?p=4950:8:168142::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:728625409049,%7Bowa_sylk%7D

----------------------------------------------------------------------
Re: exporting data from oracle to excel worksheet [message #73954 is a reply to message #68971] Sun, 08 August 2004 20:03 Go to previous messageGo to next message
Tran Le Thai
Messages: 2
Registered: August 2004
Junior Member
exporting data from oracle to excel worksheet
Re: exporting data from oracle to excel worksheet [message #208753 is a reply to message #68961] Tue, 12 December 2006 02:19 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Why is it that people think that reporting their own messages (in contravention of the forum guidelines) will result in a quicker answer?

Do not report your own messages in an attempt to get preferential treatment - it never works.
Previous Topic: Running OS command using java procedure in Oracle
Next Topic: impdp errors when moving database to new server
Goto Forum:
  


Current Time: Thu Dec 08 10:34:23 CST 2016

Total time taken to generate the page: 0.13575 seconds