Reading Microsoft Access files in Java

Question

How to read (and write) MS Access files (.mdb) in Java? Is there any open-source jdbc driver for MS Access?

Answer 1

You can use the open source Jackcess library to read an Access database through Java.

However, from the project FAQ:

Jackcess currently supports only Access 2000 databases. Access 2003 is not supported.

For later versions of Access, you can use Sun's JDBC-ODBC Bridge (step-by-step tutorial).

Answer 2

If you'd like to use Access as a JDBC database, check out the JDBC-ODBC Bridge driver.