Hello I have spend a lot of time trying to figure out how to access an MS Access (.accdb) from matlab. The documentation is confusing. Can I run SQL commands on an access database without the Database toolbox ?

2015 7 9
1 个回答
更新时间：2015 7 9
5 次查看（30 天）

0 个投票

Hello I have spend a lot of time trying to figure out how to access an MS Access (.accdb) from matlab. The documentation is confusing. Can I run SQL commands on an access database without the Database toolbox ?

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

回答（1 个）

Sanjay
Sanjay 2015-7-9

0 个投票

conn = actxserver('ADODB.Connection')
connString = 'Provider=Microsoft.Ace.OLEDB.12.0; Data Source = Database7.accdb;User Id=;Password=;';
conn.Open(connString)
r=conn.invoke('execute', 'select * from Table1');
I have come this far. the r variable seems to have something in it. But how do I pull it out in matlab workspace?

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

提问:

Sanjay
Sanjay
2015-7-9

回答：

Sanjay
Sanjay
2015-7-9

Community Treasure Hunt

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

Start Hunting!

Translated by