Description
Reading or writing an .mdb or .accdb Access database from Java usually means installing an ODBC driver, configuring a data source and going through the JDBC-ODBC bridge — Windows-only, and dependent on Access components being installed. Jackcess takes another route: a pure-Java implementation that parses the Access file format directly, with no ODBC and no Microsoft components, so it reads and writes .mdb / .accdb on any platform.
It is not an application and has no GUI — it is a library for developers. Open a database file, iterate its tables, read rows and get each field's typed value, or the other way around, create tables and write new rows, in a few lines of code; it supports the Access 2000 through 2019 formats. It is commonly used for data migration, bulk import/export and wiring legacy Access data into new programs. Apache 2.0 licensed and available as a Maven dependency, with a companion Jackcess Encrypt for encrypted databases.
Pure Java, cross-platform: it parses the Access format itself, without ODBC or any Microsoft component, reading and writing on Windows, Linux and macOS.
Read and write .mdb / .accdb: open a file, iterate tables, read rows and get typed values, and create tables, insert and update rows.
Multiple format versions: supports the Access 2000 through 2019 database file formats.
Built for integration: embed it as a library in Java applications for data migration, bulk import/export and connecting legacy Access data.
Open and extensible: Apache 2.0 licensed, available as a Maven dependency, with Jackcess Encrypt for encrypted databases.
It is not an application and has no GUI — it is a library for developers. Open a database file, iterate its tables, read rows and get each field's typed value, or the other way around, create tables and write new rows, in a few lines of code; it supports the Access 2000 through 2019 formats. It is commonly used for data migration, bulk import/export and wiring legacy Access data into new programs. Apache 2.0 licensed and available as a Maven dependency, with a companion Jackcess Encrypt for encrypted databases.
Features
Pure Java, cross-platform: it parses the Access format itself, without ODBC or any Microsoft component, reading and writing on Windows, Linux and macOS.
Read and write .mdb / .accdb: open a file, iterate tables, read rows and get typed values, and create tables, insert and update rows.
Multiple format versions: supports the Access 2000 through 2019 database file formats.
Built for integration: embed it as a library in Java applications for data migration, bulk import/export and connecting legacy Access data.
Open and extensible: Apache 2.0 licensed, available as a Maven dependency, with Jackcess Encrypt for encrypted databases.
