Connection to an Access database

2 views (last 30 days)
Dinh Xuan TRAN
Dinh Xuan TRAN on 27 Jul 2015
Commented: Guillaume on 27 Jul 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

Answers (1)

Guillaume
Guillaume on 27 Jul 2015
Edited: Guillaume on 27 Jul 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 Comments
Dinh Xuan TRAN
Dinh Xuan TRAN on 27 Jul 2015
Thks Guillaume. How to set up the odbc connection ?
Guillaume
Guillaume on 27 Jul 2015
As I said, follow the instructions. If something is not clear in the instructions, then say what it is specifically.

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!