How to import the data from MS Acess database?

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.

[Ran Chen]

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'?

Answer 1

[Charles Kim]

Thanks for the advice.

Answer 2

[Charles Kim]

Matlab is x64 and MS Office 2013 Access is x32.

Answer 3

[Ran Chen]

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