Fetching data from Access query in MATLAB

6 次查看（过去 30 天）
Jared
Jared 2014-12-4
回答： Roger Wohlwend 2014-12-5
I have the database toolbox and have been able to import Access table data into MATLAB using the fetch command. When I use the same process to try and fetch data from an Access query I'm getting an invalid cursor error. Here is the SQL statement I'm using in MATLAB.
curs = exec(conn,'select Return_Value from qry_DFAMonthly');
I'm getting the following error message:
Message: 'Invalid Cursor: ODBC Driver Error: [Microsoft][ODBC Microsoft Access Driver] Undefined f...'
Thanks for any help,
JK

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

回答（1 个）

Roger Wohlwend
Roger Wohlwend 2014-12-5
There seems to be something wrong with your database connection, or your query does not exist, or the field. Check those three items.

类别

在 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!

Translated by