Connection to an Access database

Hi all, I wish to access a query (named QRY1) defined in an Access Database (named "DB"), saved locally in my computer. Let's set the path equal to : Path1 = C:\Folder1\Folder2\DB.mdb I found out about the conn = database(instance,username,password) function. Can anyone help me about the matlab command to do so ? What to write as "instance" ? For information, no password required to open the database. Thanks

Risposte (1)

Guillaume
Guillaume il 27 Lug 2015
Modificato: Guillaume il 27 Lug 2015
Follow the instructions in the documentation to set up your database connection. Once you've set up your odbc connection you open the database with
conn = database.ODBCConnection(nameofconnectionyousetup, '', '')

2 Commenti

Thks Guillaume. How to set up the odbc connection ?
As I said, follow the instructions. If something is not clear in the instructions, then say what it is specifically.

Accedi per commentare.

Richiesto:

il 27 Lug 2015

Commentato:

il 27 Lug 2015

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by