MatLab r2020b from Database Toolbox - How to Configure Data Source from Microsoft 2016 MSExcel(64Bit) & MSAccess(64bit)

Dear MatLab Support,

Please refer to enclosed Attachment "QUERY_MatLab_r2020b_Database_Toolbox_ver_20210205"

I have recently acquired MatLab r2020b Software, and I require MatLab Technical Support/Assistance to Configure MatLab - Database Toolbox to Configure Data Source selection from Microsoft 2016 Excel&Access 64bit.

The configuration provided in the currently installed version of MatLab r2020b is Microsoft 2016 Excel&Access (32bit).

Thank You and BEST Regards,

LOGAN

e-mail: [e-mail]

Mobile [phone]

Answer 1

[Rohit Pappu]

The data source configuration can be done using configureODBCDataSource. Additional documentation can be found here

[A.Logan Mudaly]

Thank You, ROHIT PAPPU, for your response.

My problem is that the Database Toolbox, default Data Source Configuration is loaded with default ODBC Excel(or, Access) (32Bit).

I need assistance on a step-by-step procedure on How to "ADD" ODBC for Microsoft Office 2016(Excel) (64Bit), because my source data table is in Excel)64bit.

Please assist in this regards.

THank You,

LOGAN

[Rohit Pappu]

Please install the necessary Microsoft Excel 64 bit ODBC drivers, before configuring the datasource