Connect To MS Access with Java


import java.sql.*;

public class ConnectToAccess
{
	public static void main(String args[])
	{
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
			Connection conn = DriverManager.getConnection("jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);
				DBQ=D:\\path_to_db\db.mdb;PWD=mypass","login","password");
			Statement command = conn.createStatement();
			ResultSet rs = command.executeQuery("select * FROM keyword");
			while (rs.next())
			{
				System.out.println(rs.getString(2));
			}

			System.out.println("Connected To Access");

		}
		catch (SQLException se)
		{
			System.out.println(se);
		}
		catch (Exception ex)
		{
			System.out.println(ex);
		}
	}
}