CODEWITHSUNDEEP
javaexcelodbc
annyka
annyka

Reputation: 121

Java ODBC connection with Excel driver

I have an ODBC connection set up with an Excel driver. How to set up this connection in a Java project in order to be able to perform SQL queries?

Upvotes: 0

Views: 364

Answers (1)

BenjaminD
BenjaminD

Reputation: 554

Java doesn't work directly with ODBC.

You have two possibilities :

  1. Use a odbc-jdbc bridge like said here and here.
  2. Use a library dedicated to Excel manipulation like Apache poi.

Upvotes: 1

Related Questions