StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p><strong>JDBC connection to Microsoft Access in Windows 7</strong></p> <p>Introduction - In this article we make a connection using JDBC to a Microsoft Access database. This connection is made with the help of a JdbcOdbc driver. You need to use the following steps for making the connection to the data base.</p> <p><strong>Creating a Database</strong></p> <p><strong>Step 1</strong> : Open Microsoft Access and select Blank data base option and give the data base name as File name option</p> <p><strong>Step 2</strong> : Create a table and insert your data into the table</p> <p><strong>Step 3</strong> : Save the table with the desired name; in this article we save the following records with the table name student.</p> <p><strong>Now Creating DSN of your data base</strong></p> <p><strong>Step 4</strong> : Open your <strong>Control Panel</strong> and than select <strong>Administrative Tools.</strong></p> <p><strong>Step 5</strong> : Click on <strong>Data Source(ODBC)-->System DSN.</strong></p> <p><strong>Step 6</strong> : Now click on <strong>add</strong> option for making a new DSN.select <strong>Microsoft Access Driver (*.mdb. *.accdb)</strong> and than click on <strong>Finish</strong></p> <p><strong>Step 7</strong> : Make your desired <strong>Data Source Name</strong> and then click on the Select option, for example in this article article we us the name mydsn</p> <p><strong>Step 8</strong> : Now you select your data source file for storing it and then click <strong>ok</strong> and then click on <strong>Create</strong> and <strong>Finish</strong></p> <p>For more details you can check this link</p> <p><a href="http://www.c-sharpcorner.com/UploadFile/433c33/jdbc-connection-to-ms-access/" rel="noreferrer">JDBC Connection to MS-Access in Windows 7</a></p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload