import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; public class Main { public static void main(String[] args) throws Exception { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager .getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" + "Dbq=C://Book1.xlsx;"); PreparedStatement s = conn .prepareStatement("SELECT * FROM [Sheet1$] WHERE [MetricMonth] = ?"); s.setString(1, "Jul-2013"); s.execute(); ResultSet rs = s.getResultSet(); if (rs != null) { while (rs.next()) { System.out.println(rs.getInt("All")); } } s.close(); conn.close(); } }