Thread Subject: queries,Access

Subject: queries,Access

From: Stephen Gay

Date: 24 Nov, 2009 13:44:20

Message: 1 of 1

Reply to this message
Add author to My Watch List
View original format
Flag as spam

I have a number of queries in an Access database. How can I run these queries directly
rather than rewrite the sql query in Matlab.

For example in querybilder I can see the existing queries, as well as the existing tables.

But if I try and open a query, I get an error message.
I also tried actxserver to open the database, (via OpenAccessProject) but this also was unsuccessful.

I am successfully using the database toolbox.


However I think Matlab can't this particular function and I need to copy the SQL from access directly into Matlab. Any comments would be appreciated.

Stephen

Tags for this Thread

Everyone's Tags:

queries, access

Add a New Tag:

Separated by commas
Ex.: root locus, bode

What are tags?

A tag is like a keyword or category label associated with each thread. Tags make it easier for you to find threads of interest.

Anyone can tag a thread. Tags are public and visible to everyone.

Tag Activity for This Thread
Tag Applied By Date/Time
queries Stephen Gay 24 Nov, 2009 08:49:06
access Stephen Gay 24 Nov, 2009 08:49:06
rssFeed for this Thread

Contact us at files@mathworks.com