How to read .accdb file in MATLAB using ODBC
4 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Friedrich
2013-7-4
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 个评论
Friedrich
2013-7-4
Or maybe start using the querybuilder in order to get started and let MATLAB generate the SQL query for you,
更多回答(0 个)
另请参阅
类别
在 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!