How can I connect ORACLE from EXCEL with JDBC?

Question

I want to connect oracle with JDBC from excel. I want to insert data to oracle when I click the button in excel, I dont want to install ora-client.Is it possible with jdbc? I use Microsoft. Thanks.

Answer 1

Using JDBC to connect to Oracle from Excel doesn't make much sense (JDBC is a Java framework for connecting to databases and therefore not suitable for Excel IMHO).

You should install the Oracle Data Access components for Windows (assuming you're using Windows; good luck if you're using a Mac); then, you can

• directly use Oracle as a data source (no need for macros); there are tons of tutorials available on the web for this, see e.g. MacLochlainns Weblog: Query Oracle Database
• write Excel plugins in .NET, using the standard .NET mechanisms to connect to Oracle databases (again, lots of tutorials available on the Web)