Using Java to retrieve data from a Microsoft Access database [duplicate]

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 stackoverflow.com/questions/21955256/… — Tunaki
– Tunaki, Commented Jul 25, 2016 at 11:54

Pablo Santa Cruz · Accepted Answer · 2011-09-24 23:46:54Z

4

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 
    }
}

answered Sep 24, 2011 at 23:46

Pablo Santa Cruz

182k33 gold badges250 silver badges300 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Mr Teeth Over a year ago

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.

Gord Thompson Over a year ago

This answer is outdated because the JDBC-ODBC Bridge has been removed from Java 8. For an alternative, see this question.

thomas · Accepted Answer · 2011-09-24 23:48:26Z

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, 2011 at 23:48

thomas

5,6492 gold badges28 silver badges35 bronze badges

1 Comment

Mr Teeth Over a year ago

thanks for the link. I will give it a read.

Mob · Accepted Answer · 2011-09-25 00:10:31Z

0

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

answered Sep 25, 2011 at 0:10

Mob

11.1k7 gold badges43 silver badges58 bronze badges

Collectives™ on Stack Overflow

Using Java to retrieve data from a Microsoft Access database [duplicate]

3 Answers 3

2 Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Linked

Related