MATLAB Answers

Can I configure ODBC datasource programmatically?

45 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.

  2 Comments

Todd Leigh
Todd Leigh on 8 Dec 2017
I have the same question... have been looking for a solution to this problem for days!

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!

Translated by