How to read .accdb file in MATLAB using ODBC
17 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I have access file 'Database.accdb', how to read this file in MATLAB.
I have created ODBC datasource, if i read this ODBC file using 'database' function. But it will not contain any message in it.
conn =
Instance: 'datbaseaccess'
UserName: ''
Driver: []
URL: []
Constructor: [1x1 com.mathworks.toolbox.database.databaseConnect]
Message: []
Handle: [1x1 sun.jdbc.odbc.JdbcOdbcConnection]
TimeOut: 0
AutoCommit: 'on'
Type: 'Database Object'
Please suggest me any one, how to read this database file in MATLAB, i am new to database toolbox.
0 Commenti
Risposta accettata
Friedrich
il 4 Lug 2013
Hi
you don't rad the file using the database command. You establish a connection with the database file. If Message is empty it means that the connection is fine. Now you can extract data using commands like fetch and exec.
4 Commenti
Friedrich
il 4 Lug 2013
Or maybe start using the querybuilder in order to get started and let MATLAB generate the SQL query for you,
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Database Toolbox in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!