Can I configure ODBC datasource programmatically?

5 vues (au cours des 30 derniers jours)
Nicholas Cunningham
Nicholas Cunningham le 2 Nov 2017
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 commentaires
Todd Leigh
Todd Leigh le 8 Déc 2017
I have the same question... have been looking for a solution to this problem for days!
Marc Youcef
Marc Youcef le 6 Juil 2018
same thing here as well ...

Connectez-vous pour commenter.

Réponses (1)

Marc Youcef
Marc Youcef le 16 Juil 2018


Community Treasure Hunt

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

Start Hunting!

Translated by