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 ?

6 visualizaciones (últimos 30 días)
Sanjay
Sanjay el 9 de Jul. de 2015
Respondida: Sanjay el 9 de Jul. de 2015
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 ?

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Sanjay
Sanjay el 9 de Jul. de 2015
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?

Categorías

Más información sobre Database Toolbox en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by