OraFAQ Forum: Other Application Suites » How do I connect to 10g with Excel 2007?

Home » Applications » Other Application Suites » How do I connect to 10g with Excel 2007? (oracle 10g, Excel 2007)

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

How do I connect to 10g with Excel 2007? [message #308151]

Fri, 21 March 2008 11:00

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!

/forum/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!