msquery

Run queries on a Microsoft Access database and have results returned to the MATLAB workspace.

Description

The msquery toolbox enables you initiate a query in a Microsoft Access database program and to transfer the results of directly into your MATLAB workspace. The columns headings from the Access query are parsed and assigned as the variable names of the appropriate columns in your MATLAB workspace. This can be run interactively using a GUI or from the MATLAB command line.

• MATLAB release: MATLAB 7 (R14)
• Other requirements: Microsoft Windows OS required

[wood Wang]

Powerful!!

[Kip Jonston]

Nice work!

[Andrew Blackburn]

It should be noted that this toolbox, because it uses ActiveX automation, will also work with Access 2000 and 2003. A very impressive bit of MATLAB coding, all accomplished without a single .mex file. Saved me all kinds of time and efford.

[Madhusudhanan Balasubramanian]

Nice toolkit. Tested on Access 2003, it works!

[wo kao]

Great work! It is just what i want. Thanks

[Alvaro Hernandez]

Great Work!...

[Dmitry Borovoy]

This is really what I need. But I've found small bug. If database doesn't contain any queries, than we get error at line 157 at the file 'opendatabase.m'.
I offer you add such code for example

if(exist('QDName'))
% Update the string presented in the listbox and highlight the first item
QDLength = length(QDName);
set(hQueryList,'String',QDName(1:QDLength),'Value',1);
else
QDLength = 0;
end
Or something else. Because otherwise program is crushed and don't work properly

[J Ng]

This toolbox is great, but I can't seem to get this to work. I'm using Access 2007 and I get the following error message.

??? Error using ==> actxserver at 91
Server creation failed. Invalid ProgID 'Access.Application'

Error in ==> openDatabase at 52
hacc = actxserver('Access.Application');

What do I need to do to correct this?

[J Ng]