Using Java to retrieve data from a Microsoft Access database

Question

I'm looking to create a Java program that retrieves data from Microsoft Access database (and possible store onto it).

Is this possible? If yes, is it complicated to do? Also are there any examples of Java programs (or code) that does this?

Thanks.

The JDBC-ODBC bridge is no more, today one can refer to http://stackoverflow.com/questions/21955256/manipulating-an-access-database-from-java-without-odbc — Tunaki, Jul 25 '16 at 11:54

score 4 · Accepted Answer · answered Sep 24 '11 at 23:46

Yes, it's perfectly possible. Java's JDBC-ODBC bridge is your best friend for this.

First, you need to configure an ODBC access to your MSAccess database.

Then, you need this simple piece of code:

import java.sql.*;

public class AccessManager {

    private Connection con;
    private Statement st;
    private static final String url="jdbc:odbc:my_access_odbc_dsn";
    private static final String className="sun.jdbc.odbc.JdbcOdbcDriver";
    private static final String user="";
    private static final String pass="";

    AccessManager()throws Exception {
        Class.forName(className);
        con = DriverManager.getConnection(url, user, pass);
        st = con.createStatement(); 
        // you can do select, insert, update, delete from 
    }
}

thanks a lot for this reply. I will look into "Java's JDBC-ODBC bridge". I've never heard of it before. The code looks like something I can work with. Again, thank you. — Mr Teeth, Sep 25 '11 at 01:19
This answer is outdated because the JDBC-ODBC Bridge has been removed from Java 8. For an alternative, see [this question](http://stackoverflow.com/q/21955256/2144390). — Gord Thompson, Jul 25 '16 at 14:20

score 1 · Answer 2 · answered Sep 24 '11 at 23:48

1

yes, this should be possible via JDBC : so it is as easy as using any other DBMS in java.

take a look at this document

answered Sep 24 '11 at 23:48

thomas

5,549
2
22
34

thanks for the link. I will give it a read. – Mr Teeth Sep 25 '11 at 01:24

score 0 · Answer 3 · answered Sep 25 '11 at 00:10

While this is perfectly possible using the JDBC-ODBC bridge. The configuration isn't easy to set up, especially if you have an architecture mismatch. Ensure you are using the same architecture for both the JDK, Driver, IDE, OS to prevent ridiculous bugs. If you're using a 64 bit OS ensure tool is also 64 bit. Same applies for 32 bits.

Tut Tut2

Using Java to retrieve data from a Microsoft Access database

3 Answers3