Fetching data from Access query in MATLAB

8 visualizaciones (últimos 30 días)
Jared
Jared el 4 de Dic. de 2014
Respondida: Roger Wohlwend el 5 de Dic. de 2014
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

Respuestas (1)

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

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by