How to import the data from MS Acess database?

1 次查看（过去 30 天）
Charles Kim
Charles Kim 2018-10-31
回答： Charles Kim 2018-11-5
After the launch, the directory is set at C:\Apps\MATLAB\R2016a\toolbox\database\dbdemos. At the command prompt,
> connA=database('SampleDB','','') > connA.Message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I followed the example, but cannot find any file that has SampleDB. I do not know how to fix the error. Eventually I hope to import the data from any database I created using MS Acess 2013. Please help.
  1 个评论
Ran Chen
Ran Chen 2018-11-5
编辑：Ran Chen 2018-11-5
Hello,
To look into the issue I need more information:
What is the bitness of MATLAB and MS Access?
Did you successfully connect to the database via 'Database Explore'?

请先登录，再进行评论。

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

采纳的回答

Charles Kim
Charles Kim 2018-11-5
Thanks for the advice.

更多回答（2 个）

Charles Kim
Charles Kim 2018-11-5
Matlab is x64 and MS Office 2013 Access is x32.
Ran Chen
Ran Chen 2018-11-5
To connect to 32-bit Microsoft Access Database from 64-bit MATLAB, please take the following steps in the attached link:
https://www.mathworks.com/matlabcentral/answers/235949-how-to-connect-to-32-bit-microsoft-access-database-from-64-bit-matlab

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2016a

Community Treasure Hunt

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

Start Hunting!

Translated by