How can I connect to Access database?

I am running 64 bit version of windows 7 and 64 bit version of MATLAB 2011, what I need to do is connect to an Access 2010 Database, execute a SQL statement and export a table to Excel. How can this be done?

Thank you in advance.

Answer 1

[Fangjun Jiang]

Use the Database Toolbox?

[Daniel]

That is what I have tried to do, at first using the demo script which comes with the toolbox, this script gives me the following error:

??? Error using ==> database.ping at 153

Invalid connection.

Error in ==> dbimportdemo at 20

ping(connA)

This is after having set up the data source for ODBC drivers.

[Kaustubha Govind]

Have you examined connA.Message to see if there was an error making the connection?

[Fangjun Jiang]

Okay, I thought you didn't know the Database Toolbox. I don't have the same OS, MATLAB version and MS Office version as you have. Are you implying the problem is due to these new version of software? Did you have the same problem in previous versions? Gosh! I envy you having all these newest gadget.