A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
Arduino in Action
this week in the
A special promo:
Enter your blog post or vote on a blogger to be featured in an upcoming Journal
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:
- if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
subject: Accessing Data from MS-Access database
Appet with data Base
How to build DSN on the fly for MS Access database JDBC access?
inserting date and time into database
reading from oracle!
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013