Connection to an Access database

4 visualizzazioni (ultimi 30 giorni)
Dinh Xuan TRAN
Dinh Xuan TRAN il 27 Lug 2015
Commentato: Guillaume il 27 Lug 2015
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
Dinh Xuan TRAN
Dinh Xuan TRAN il 27 Lug 2015
Thks Guillaume. How to set up the odbc connection ?
Guillaume
Guillaume il 27 Lug 2015
As I said, follow the instructions. If something is not clear in the instructions, then say what it is specifically.

Accedi per commentare.

Community Treasure Hunt

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

Start Hunting!

Translated by