MATLAB: How to import data from a .mdb (Microsoft Access Database) file into MATLAB

accessdatabaseimportMATLABmdb

I have a '.mdb' file which contains data that I want to import into MATLAB. Is there a way I can do this? If so, how?

Best Answer

To import data from an '.mdb' file into MATLAB, you can use the Database Explorer app from the Database Toolbox.

https://www.mathworks.com/help/database/ug/databaseexplorer-app.html

There is also a MATLAB File Exchange program called 'msquery' that gives the same functionality.

https://www.mathworks.com/matlabcentral/fileexchange/5660-msquery

Related Solutions

MATLAB: Exporting MATLAB data to .MDB

You can use database toolbox

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

Best Answer

Related Solutions

MATLAB: Exporting MATLAB data to .MDB

MATLAB: Access Apache Hive using ODBC driver

Related Question