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 ?

15 vues (au cours des 30 derniers jours)
Sanjay
Sanjay le 9 Juil 2015
Réponse apportée : Sanjay le 9 Juil 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 ?

Connectez-vous pour répondre à cette question.

Réponses (1)

Sanjay
Sanjay le 9 Juil 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?

Catégories

En savoir plus sur Database Toolbox dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by