I've been asked to connect to and Microsoft Access database to extract address information from a full address field. (This will eventually be moved to a MS SQL 2000 server). I've been working with Oracle ... Can someone point in the right direction. The Access db is on my hard drive. David
hi, i'm no expert in Microsoft Access... try using the following code..where dsn_name is the name of the data source name(DSN) created for the database. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc dbc:[B]dsn_name/B]" , "login_name", "password"); Statement s = con.createStatement(); --sumana.