Home » Applications » Other Application Suites » How do I connect to 10g with Excel 2007? (oracle 10g, Excel 2007)
icon5.gif  How do I connect to 10g with Excel 2007? [message #308151] Fri, 21 March 2008 11:00 Go to next message
armeck
Messages: 2
Registered: March 2008
Location: GA, USA
Junior Member
Hey all, I apologize in advance if this question has been asked before but I am utterly stumped.

We have just finished creating our first ever cube via Data Wrehouse builder and wanted a "nice" way to view the data for the end users. It seems that Excel 2007 can do this, but I am at a loss how to even connect!

Here is what I am doing:
1. Click Data tab
2. Click From Other Sources
3. From data Connection Wizard

Then I select the OLE DB PRovider for Oracle option as it is the only Oracle branded option to pick. At this point I am not sure what to input, as I only have one line for "Server name", nothing I input seems to work!

./fa/4037/0/

I have a feeling I am missing something very simple here, but I'll be danged if I know what it is.

I greatly appreciate any feedback you can provide for me.

Thanks!
Re: How do I connect to 10g with Excel 2007? [message #308157 is a reply to message #308151] Fri, 21 March 2008 11:58 Go to previous message
armeck
Messages: 2
Registered: March 2008
Location: GA, USA
Junior Member
I get this error when trying to connect, which is odd for me as I can connect with Warehouse Builder and SQLDeveloper.
./fa/4039/0/
Previous Topic: Item Master File cleansing
Next Topic: SQRW - How does one buy/download?
Goto Forum:
  


Current Time: Mon Sep 22 11:40:54 CDT 2014

Total time taken to generate the page: 0.12824 seconds