How to read (and write) MS Access files (.mdb) in Java? Is there any open-source jdbc driver for MS Access?
Asked
Active
Viewed 9,823 times
8
-
MDF is not a common Jet file extension. – David-W-Fenton Mar 18 '09 at 00:44
1 Answers
13
You can use the open source Jackcess library to read an Access database through Java (currently supporting Access versions 2000-2007).
![](../../users/profiles/1288.webp)
Bill the Lizard
- 369,957
- 201
- 546
- 842
-
-
@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
-
2jackcess now supports access 2010 (although it doesn't support macros). – jtahlborn Jun 29 '12 at 17:24