File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Accessing Data from MS-Access database
Joined: Sep 24, 2002
Sep 24, 2002 05:58:00
Which is most suitable driver to access data from MS-Access database?
Joined: Nov 06, 2000
Sep 24, 2002 06:11:00
You will have to use the JDBC-ODBC bridge. It should have come with the JDK.
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Joined: Feb 09, 2002
Sep 24, 2002 06:19:00
the code to load the driver for Access is:
// loads the driver DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver()); // defines the data source for driver String sourceURL = "jdbc :-o dbc:<databasename>; // creates the dbase connection Connection conn = DriverManager.getConnection(soureURL);
Research the rest of code so you learn it on your own.
I agree. Here's the link:
subject: Accessing Data from MS-Access database
How to build DSN on the fly for MS Access database JDBC access?
inserting date and time into database
reading from oracle!
Appet with data Base
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015