Insert records into MS-Access database using JDBC

MS-Access is a type of database from Microsoft Office product. This is a file type database to access quickly and easily. In previous tutorial we learnt  How to Connect MS Access Database using JDBC go through this one time to configure your driver and Connection.

For any database the we use the same procedure to insert records into database but DataSourceName(DSN) and driver class names will be unique. If you have multiple databases on your system then you should configure each one with different datasource names with JDBC.

Read more..

Connecting MS Access Database using JDBC Driver

To connect MS Access database using java we should use JDBC drivers.
We should follow below given steps to connect MS Access database using JDBC.

• Create MS Access database file
• Create a table in the database
• Create a Data Source Name using Microsot Access Driver
• Write a java program to connect MS Access database

Here we are just connecting to MS Access database to test our connection. Apart from that nothing we are doing. We can use MS Access as a database for minor and small scale projects. Adding and retrieving data is so simple with this and several advantages like Easy to Use,Great Storage Capacity, Flexibility, Data Importing and Exporting, Multi User support and Remote Use.

Read more..