Home » SQL & PL/SQL » SQL & PL/SQL » How to show oracle views data into Microsoft Exel Sheet (merged)
How to show oracle views data into Microsoft Exel Sheet (merged) [message #388770] Thu, 26 February 2009 03:17 Go to next message
skkazmi
Messages: 44
Registered: April 2006
Member
Hi all,

I like to know is there any posibility to show current oracle view data into microsoft excel sheet.

Is anyone have any solution regarding.

Best Regards,
Kazmi
Re: How to show oracle views data into Microsoft Excel Sheet [message #388777 is a reply to message #388770] Thu, 26 February 2009 03:28 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Create an Odbc connection for the Oracle database, and use the Excel Tools > Import External Data > New Database Query to setup a query against the database.
Re: How to show oracle views data into Microsoft Excel Sheet [message #389296 is a reply to message #388777] Sat, 28 February 2009 04:55 Go to previous message
skkazmi
Messages: 44
Registered: April 2006
Member
Thanks a lot.
Previous Topic: Writing Hierarchical data into another table
Next Topic: Regroup table rows by id
Goto Forum:
  


Current Time: Sun Dec 04 04:19:09 CST 2016

Total time taken to generate the page: 0.04018 seconds