How to connect oracle odbc for excel 2010?

Asked By Virginia Adams 20 points N/A Posted on - 10/05/2012

Hello,

How to connect oracle ODBC for excel 2010?

In this kind of database program I have to consult first the proper way of connecting all my data files stored in Microsoft excel 2010 to an oracle database server.

Is it possible for me to import all my files to a database system?

• Status: Open
• Question Views: 1410
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Mackt Salaop

Go To Solution

Best Answer

Best Answer

Answered By Mackt Salaop 5 points N/A #173220

How to connect oracle odbc for excel 2010?

Hi,

It is possible to link the excel files with Oracle database. The PROD will work as linking server for connection.

 

The technique is slightly complicated.

 

So, visual aids are more supportive rather than written instructions.

 

Another technique can be found, but not so much favorable as it is.

 

See the full technique in the link provided.

About Mackt Salaop

Questions
3

Answers
99

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 10/05/2012
• Question Category: MS Excel

Answered By Kaile Smith 0 points N/A #173221

How to connect oracle odbc for excel 2010?

Hi, Virginia!

Connecting Oracle ODBC to excel 2010 composes many processes.

To make it easy, you will perform this actually by following the steps/instructions on this URLs

Connecting with Oracle Accessing Oracle via Access and Excel

Connecting to Microsoft Excel using Oracle Data Integrator

If you have some questions about this process, you can visit this URL

Read this carefully to connect Oracle ODBC to Excel.

Thank You!

 

About Kaile Smith

Questions
1

Answers
100

Best Answers
25

• Vote Up 0 Vote Down

• Posted on - 10/05/2012
• Question Category: MS Excel