OraFAQ Forum: Server Utilities » Transfer oracle data to Excel

Home » RDBMS Server » Server Utilities » Transfer oracle data to Excel

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

Transfer oracle data to Excel [message #73804]

Wed, 14 July 2004 23:32

Trupti
Messages: 5
Registered: February 2003

Junior Member

Hello

How do i transfer / load data from an oracle table say emp from scott/tiger schema to an Excel sheet. Is it possible using SQL*Loader. If yes please let em know the procedure step by step with commands. If not please let me know if there is any other way.

I'm using Oracle 9i.

Thanks

Trupti

Report message to a moderator

Re: Transfer oracle data to Excel [message #73805 is a reply to message #73804]

Thu, 15 July 2004 02:43

Frank Naude
Messages: 4587
Registered: April 1998

Senior Member

Hi,

See http://www.orafaq.com/faqloadr.htm#UNLOAD

The first example creates a CSV file that can be loaded into MS-Excel.

Best regards.

Frank

Report message to a moderator

Re: Transfer oracle data to Excel [message #73838 is a reply to message #73804]

Wed, 21 July 2004 21:55

premesh
Messages: 2
Registered: July 2004

Junior Member

hi
u can use visual basics as vb has a tool to save data in excel sheet u can use excel.application,workbook.add .

Report message to a moderator

Previous Topic:	Why the database could not start?
Next Topic:	password in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 08:34:18 CST 2024