Reading Microsoft Access files in Java

java jdbc ms-jet-ace
user68109 picture user68109 · Mar 16, 2009 · Viewed 9.9k times · Source

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

Answer

Bill the Lizard picture Bill the Lizard · Mar 16, 2009

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

Related questions

Solving a "communications link failure" with JDBC and MySQL

I'm trying to connect to the local MySQL server but I keep getting an error. Here is the code. public class Connect { public static void main(String[] args) { Connection conn = null; try { String userName = "myUsername"; String password = "myPassword"; String url = "…

Read More
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

I'm working on getting my database to talk to my Java programs. Can someone give me a quick and dirty sample program using the JDBC? I'm getting a rather stupendous error: Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.…

Read More
Java JDBC - How to connect to Oracle using Service Name instead of SID

I have a Java application that uses JDBC (via JPA) that was connecting to a development database using hostname, port and Oracle SID, like this: jdbc:oracle:thin:@oracle.hostserver1.mydomain.ca:1521:XYZ XYZ was the Oracle SID. Now I …

Read More