Connection to an Access database

2 vues (au cours des 30 derniers jours)
Dinh Xuan TRAN
Dinh Xuan TRAN le 27 Juil 2015
Commenté : Guillaume le 27 Juil 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

Réponses (1)

Guillaume
Guillaume le 27 Juil 2015
Modifié(e) : Guillaume le 27 Juil 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 commentaires
Dinh Xuan TRAN
Dinh Xuan TRAN le 27 Juil 2015
Thks Guillaume. How to set up the odbc connection ?
Guillaume
Guillaume le 27 Juil 2015
As I said, follow the instructions. If something is not clear in the instructions, then say what it is specifically.

Connectez-vous pour commenter.

Community Treasure Hunt

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

Start Hunting!

Translated by