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 ?

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 ?

Answer 1

[Sanjay]

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?