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

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

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.

Sign in to comment.

Asked:

on 27 Jul 2015

Commented:

on 27 Jul 2015

Community Treasure Hunt

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

Start Hunting!