Can I configure ODBC datasource programmatically?

24 views (last 30 days)
Nicholas Cunningham
Nicholas Cunningham on 2 Nov 2017
Answered: Marc Youcef on 16 Jul 2018
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.

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!