данные из excel в oracle через odbc

Microsoft Windows 7  (15)

Microsoft Vista  (13)

Microsoft Office  (10)

Microsoft Excel  (11)

Internet Explorer  (1)

Internet Connection  (1)

Hardware Problems  (1)

DSL-Modem/Router  (1)

Collaborate Conference  (4)

basic programming  (2)

Analytical function  (1)

Mail (will not be published) (required)

November 13th, 2011 at 12:59 am

Once you’ve downloaded it, you can return to this post where you . You should take note that , like the approach they’ve chosen with MySQL’s ODBC driver. As always, I hope this helps.

This driver contains the necessary OLE DB and ODBC drivers, as you can see in this screen shot.

For those who don’t have an Oracle instance running locally, you can download the Oracle Data Access Components for Windows from the Oracle web site. It’s in the driver sections, as shown in the screen capture below:

It appears I assumed too, like everyone would know that it’s on Windows 7 when Oracle 11g (or another Oracle database) is installed locally. The person who posed the question doesn’t have Oracle installed locally and can’t install it.

Somebody was trying to query Oracle via Microsoft Excel 2007, and didn’t have an Oracle ODBC Data Source that enable them to choose Oracle. I’d referred them to this post on to Windows 7 but that didn’t help enough. Posting this screen shot may not have helped either.

Michael McLaughlin's Technical Blog

ODBC required for Excel to Query Oracle | MacLochlainns Weblog