MATLAB: How to import the data from MS Acess database

databaseimportMATLAB

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.

Best Answer

Thanks for the advice.

Related Solutions

MATLAB: Access Apache Hive using ODBC driver

I've tested Hive access via JDBC Driver, but not ODBC Driver yet, but I think possibly, yes.

First, 64 bit ODBC Driver is requied.

Next, configure ODBC data source in Database Toolbox. And I think you can access to Hive

datasource = 'Hive'; % The name of datasource specified in configureODBCDataSource
username = 'XXX';
password = 'YYY';
conn = database(datasource, username, password);
selectquery = 'SELECT TOP 10 * FROM TABLENAME';
data = select(conn,selectquery);

Ref: https://www.mathworks.com/help/database/ug/database.html#btcofz6

MATLAB: How to find the Microsoft Access Driver (.mdb, .accdb) if it is not listed in the ODBC Data Source Administrator

The Microsoft Access Driver (.mdb,.accdb) does not appear in the ODBC Data Source Administrator dialog box when the bitness of the operating system and Microsoft Access is different. This mismatch occurs when you setup a data source for a 32-bit Microsoft Access database using a 64-bit MATLAB.

To solve this, follow one of these methods:

- Use a 64-bit version of Microsoft Access.

- Refer to the workaround in https://www.mathworks.com/matlabcentral/answers/235949-how-to-connect-to-32-bit-microsoft-access-database-from-64-bit-matlab to connect to a 32-bit version of Microsoft Access. Then, create an ODBC data source using MATLAB. For details about creating ODBC data sources, see

https://www.mathworks.com/help/database/ug/configuring-driver-and-data-source.html

If the above methods do not work and you are using a MATLAB version prior to R2016a, use a 32-bit MATLAB and run 32-bit ODBC Data Source Administrator by following these steps:

1. Navigate to the "C:\Windows\SysWOW64" folder.

2. Find and right-click the executable "odbcad32.exe", and click "Run as administrator". (Running this executable as administrator grants you administrator privileges to create data sources on the computer.)

3. Create an ODBC data source. For details about creating ODBC data sources, see

https://www.mathworks.com/help/database/ug/configuring-driver-and-data-source.html

Best Answer

Related Solutions

MATLAB: Access Apache Hive using ODBC driver

MATLAB: How to find the Microsoft Access Driver (*.mdb, *.accdb) if it is not listed in the ODBC Data Source Administrator

Related Question

MATLAB: How to find the Microsoft Access Driver (.mdb, .accdb) if it is not listed in the ODBC Data Source Administrator