Can I configure ODBC datasource programmatically?

I have a directory of many Microsoft Access (*.mdb) database files. I can access the data and perform SQL queries using the Database Explorer from the Database Toolbox. To do this I have to manually configure in the GUI each database by choosing the Microsoft Access driver, assigning the data source name, and choosing the database (*.mdb) file.

Is there a way to write a script that configures each database without using the Database Explorer and GUI? There are hundreds of *.mdb files and I do not want to do this manually. Every example I see uses the Database Explorer method.

[Todd Leigh]

I have the same question... have been looking for a solution to this problem for days!

[Marc Youcef]

same thing here as well ...

Answer 1

[Marc Youcef]

Here is the answer : https://nl.mathworks.com/matlabcentral/answers/392123-how-to-use-database-toolbox-to-query-accdb-mdb-file-programmatically-without-jdbc-odbc-bridge-on-win