Monday, April 25, 2011

Reading Microsoft Access files in Java

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

From stackoverflow
  • 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).

    Yuval A : Jackcess is good, but it only works for Access 2000 (JET4) files.
    Bill the Lizard : @Yuval: Thanks, I edited my answer to include that information.
  • If you'd like to use Access as a JDBC database, check out the JDBC-ODBC Bridge driver.

0 comments:

Post a Comment