current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Hello ppl I am trying to work with databases and I am new to Matlab. I want to manipulate databeses created in MS Access but I don't know(I hope find a way to enter data from GUI (this GUI created using matlab ) and save in database) I've designed the user interface in MATLAB, and create a database in MS Access The problem I do not know how I connect between the database and MATLAB I find some code to how connect between it.

dbpath = ['C:\Users\Esra\Documents\Esra.accdb'];
conurl = [['jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ='] dbpath];
con = database('','','','sun.jdbc.odbc.JdbcOdbcDriver', conurl);

I hope find good code or book about this .

final , i don not know if it is the correct place to my question or not , if not ,please put my question in correct place

share|improve this question
add comment

1 Answer

up vote 0 down vote

You need to run SQL queries on the database; you can do this with database.fetch (and a few other friends).

The example query from the docs:

conn = database('dbtoolboxdemo','','');
setdbprefs('DataReturnFormat','cellarray')
results = fetch(conn, 'select productdescription from producttable')

% Not in the example in the docs: this syntax, which I prefer, is also supported
results = conn.fetch('select productdescription from producttable');

Note that you will also need to know how to write SQL. For that, there are plenty of resources online - you just have to search for them.

share|improve this answer
 
first thanks, but my database I create using MS Access not using SQL –  esra Jun 13 '13 at 13:51
 
If anyone have PDF ,or good code how to connect database using (MS Access) to matlab –  esra Jun 13 '13 at 13:58
 
Access databases support SQL queries via the Microsoft Access Driver that you are loading in the connection string. You need to write an SQL query to get at your data. –  wakjah Jun 13 '13 at 17:08
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.