Can I configure ODBC datasource programmatically?

10 visualizaciones (últimos 30 días)
Nicholas Cunningham
Nicholas Cunningham el 2 de Nov. de 2017
Respondida: Marc Youcef el 16 de Jul. de 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 comentarios
Todd Leigh
Todd Leigh el 8 de Dic. de 2017
I have the same question... have been looking for a solution to this problem for days!
Marc Youcef
Marc Youcef el 6 de Jul. de 2018
same thing here as well ...

Iniciar sesión para comentar.

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Marc Youcef
Marc Youcef el 16 de Jul. de 2018

Categorías

Más información sobre Database Toolbox en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by