How to connect oracle odbc for excel 2010?

Asked By 20 points N/A Posted on -
qa-featured

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?

SHARE
Best Answer by Mackt Salaop
Best Answer
Best Answer
Answered By 5 points N/A #173220

How to connect oracle odbc for excel 2010?

qa-featured

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.
 
Answered By 0 points N/A #173221

How to connect oracle odbc for excel 2010?

qa-featured

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!

 

Related Questions