ms access into array

By using JDBC you can bring all your phone numbers in to an array

now i am sending just sample program for accessing number from excel look into it..

import java.io.*;

import java.sql.*;

class MyP1

{

public static void main(String cc[])

{

try{

DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());

Connection con = DriverManager.getConnection("jdbc:odbc:GsrCBook1","","");

Statement st = con.createStatement();

ResultSet rs = st.executeQuery("select Number from [Sheet1$]");

while(rs.next())

{

System.out.println(rs.getString(1));

}

}

catch(Exception e)

{System.out.println(e);}

}

}

first you need to create User/System DSN in your data source

for details how to create DSN please search http://www.javaworld.com/javaworld/javaqa/2001-06/04-qa-0629-excel.html

Chowdarya at 2007-7-10 11:56:17 >