How to read .accdb file in MATLAB using ODBC
조회 수: 17 (최근 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!