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

Question

A.Logan Mudaly 2021-2-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/737212-matlab-r2020b-from-database-toolbox-how-to-configure-data-source-from-microsoft-2016-msexcel-64bit

评论： Rohit Pappu 2021-2-9

QUERY_MatLab_r2020b_Database_Toolbox_ver_20210205.txt

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: logan_mudaly@yahoo.com

Mobile (+974) 66587167

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Rohit Pappu 2021-2-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/737212-matlab-r2020b-from-database-toolbox-how-to-configure-data-source-from-microsoft-2016-msexcel-64bit#answer_618467

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

2 个评论
显示无隐藏无

A.Logan Mudaly 2021-2-9

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 2021-2-9