How to read .accdb file in MATLAB using ODBC
11 ビュー (過去 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!