Can I configure ODBC datasource programmatically?

조회 수: 17 (최근 30일)
Nicholas Cunningham
Nicholas Cunningham 2017년 11월 2일
답변: Marc Youcef 2018년 7월 16일
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
Todd Leigh
Todd Leigh 2017년 12월 8일
I have the same question... have been looking for a solution to this problem for days!
Marc Youcef
Marc Youcef 2018년 7월 6일
same thing here as well ...

댓글을 달려면 로그인하십시오.

답변 (1개)

Marc Youcef
Marc Youcef 2018년 7월 16일


Help CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기


Community Treasure Hunt

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

Start Hunting!

Translated by