How to import the data from MS Acess database?

조회 수: 2 (최근 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 CenterFile 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