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 ?

5 次查看（过去 30 天）
Sanjay
Sanjay 2015-7-9
回答： Sanjay 2015-7-9
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
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?

类别

在 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