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?

MDF is not a common Jet file extension. – David-W-Fenton Mar 18 '09 at 00:44 — David-W-Fenton, Mar 18 '09 at 00:44

Bill the Lizard · Accepted Answer · 2011-01-28T12:19:17.643

15

You can use the open source Jackcess library to read an Access database through Java (currently supporting Access versions 2000-2007).

edited Jan 28 '11 at 12:19

answered Mar 16 '09 at 17:06

Bill the Lizard

Jackcess is good, but it only works for Access 2000 (JET4) files. – Yuval Adam Mar 16 '09 at 17:13
@Yuval: Thanks, I edited my answer to include that information. – Bill the Lizard Mar 16 '09 at 17:49
@Bill the Lizard can you update this entry? Jackcess now supports Access 2000 through 2007. – Nitrodist Jan 28 '11 at 07:01
Saying that it supports A2007 raises the question of whether it supports A2010. Very little of the data format changed, but A2010 introduced table-level data macros (which can be used to implement triggers), and that's a significant change. – David-W-Fenton Jan 28 '11 at 23:34
@David: I don't have Access 2010 to test with, but I imagine they'd claim support if it worked, so probably not. – Bill the Lizard Jan 29 '11 at 04:28
3

jackcess now supports access 2010 (although it doesn't support macros). – jtahlborn Jun 29 '12 at 17:24

1 Answers1