0

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?

annyka
  • 121
  • 6

1 Answers1

1

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.
BenjaminD
  • 488
  • 3
  • 13