Connection to an Access database

2 visualizaciones (últimos 30 días)
Dinh Xuan TRAN
Dinh Xuan TRAN el 27 de Jul. de 2015
Comentada: Guillaume el 27 de Jul. de 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

Respuestas (1)

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

Iniciar sesión para comentar.

Community Treasure Hunt

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

Start Hunting!

Translated by