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

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.

Preguntada:

el 27 de Jul. de 2015

Comentada:

el 27 de Jul. de 2015

Community Treasure Hunt

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

Start Hunting!

Translated by