| Excel-Oracle Connectivity Problem [message #101397] |
Mon, 13 September 2004 22:41  |
Avra
Messages: 65
Registered: July 2004
|
Member |
|
|
HI... I'm Using Ofiice2000, Windows 2000 prof and Oracle Enterprise Edition.... I'm trying to retrive data from Oracle into excel... In excel I'm using the follwing option.... Data - Get External Data - Create Database Query.... Now it's asking for an ODBC.... I've already created an ODBC connectivity by Microsoft ODBC Driver for Oracle...... So I'm chhosing that DSN... But it generally fails to connect... After attempting 5-6 times, I'm able to connect...... Can you tell me what is the reason behind this problem?.... Is there any compitability issue?.... Is there any other way to retrive data from oracle into excel?
Thanks............
|
|
|
|
|
|
|
|
 Re: Excel-Oracle Connectivity Problem [message #133666 is a reply to message #101397] |
Sun, 21 August 2005 04:55  |
tmuller
Messages: 1
Registered: August 2005
|
Junior Member |
|
|
Hi,
you can do it with java, xml and xslt transformation. Excel since version MS Excel 2000 can view data in xml.
So you can in java code retrieve data from oracle, store it in
xml and then you can take some powerful library writen in java which take stored xml and your xslt stylesheet. This library can
generate special xml file format, which can Excel view without
any problems.
It's no problem transform xml to pdf, xls, html, svg etc. with
xsl or xslt stylesheet.
If you are interesting about java, write me and i will send you
a sample xml, xslt and java code witch this function.
I'm sorry for my english.
Regards
Tomas Muller
|
|
|
|
| Re: Excel-Oracle Connectivity Problem [message #136278 is a reply to message #133666] |
Wed, 07 September 2005 05:32 |
Scott Cowan
Messages: 15
Registered: February 2004
|
Junior Member |
|
|
Have a look at www.oraxcel.com, they have a product called SQL*XL , which provides a menu driven way on selecting / inserting /updating /deleting oracle data directly from excel.
It has a nice interface which makes product easy to start with.
I've spent last few days using it and you can embed oracle sql statements with cell references etc and then execute them as a batch.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
