How to read .accdb file in MATLAB using ODBC

4 次查看（过去 30 天）

Chandra Shekhar 2013-7-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/81071-how-to-read-accdb-file-in-matlab-using-odbc

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Friedrich 2013-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/81071-how-to-read-accdb-file-in-matlab-using-odbc#answer_90796

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.