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

Antworten (1)

Guillaume
Guillaume am 27 Jul. 2015
Bearbeitet: Guillaume am 27 Jul. 2015

0 Stimmen

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 Kommentare

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

Melden Sie sich an, um zu kommentieren.

Gefragt:

am 27 Jul. 2015

Kommentiert:

am 27 Jul. 2015

Community Treasure Hunt

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

Start Hunting!

Translated by