How can I connect to Access database?

2011 6 20
1 个回答
16 次查看（30 天）

0 个投票

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.

请先登录，再回答此问题。

回答（1 个）

Fangjun Jiang
Fangjun Jiang 2011-6-20

0 个投票

Use the Database Toolbox?

3 个评论
显示 1更早的评论 隐藏 1更早的评论

Daniel
Daniel 2011-6-20
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
Kaustubha Govind 2011-6-20
Have you examined connA.Message to see if there was an error making the connection?
Fangjun Jiang
Fangjun Jiang 2011-6-21
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.

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

提问:

Daniel
Daniel
2011-6-20

Community Treasure Hunt

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

Start Hunting!

Translated by