Connection to an Access database

6 次查看（过去 30 天）
Dinh Xuan TRAN
Dinh Xuan TRAN 2015-7-27
评论： Guillaume 2015-7-27
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

请先登录，再回答此问题。

回答（1 个）

Guillaume
Guillaume 2015-7-27
编辑：Guillaume 2015-7-27
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 个评论
Dinh Xuan TRAN
Dinh Xuan TRAN 2015-7-27
Thks Guillaume. How to set up the odbc connection ?
Guillaume
Guillaume 2015-7-27
As I said, follow the instructions. If something is not clear in the instructions, then say what it is specifically.

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by