Connection to an Access database

2 Ansichten (letzte 30 Tage)
Dinh Xuan TRAN
Dinh Xuan TRAN am 27 Jul. 2015
Kommentiert: Guillaume am 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

Antworten (1)

Guillaume
Guillaume am 27 Jul. 2015
Bearbeitet: Guillaume am 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 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.

Community Treasure Hunt

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

Start Hunting!

Translated by