How to configure an ODBC data source programmatically?

Hello.

I need to query data from a Microsoft Access database. I can easily set up an ODBC data source with the Database explorer and then query it either with the same app or with code. . Unfortunately, the database is split into hundreds of .mdb files, so in order to query them, I'd need to set up hundreds of ODBC data sources manually. Is there a way to set up the data sources programmatically? Or alternatively, is there a way to query the contents of an .mdb file without having to set it up as an ODBC data source first?

Thank you.

[Kojiro Saito]

Did you set ODBC data sources with a folder not .mdb file?

Step 3. Set up the data source using the Database Explorer app

7.

b. In the Map Network Drive dialog box, specify the folder containing the database you want to use. Ensure that you map to the folder and not the database file.

https://www.mathworks.com/help/database/ug/microsoft-access-odbc-windows.html

[Antonio]

Hello. I have actually been unable to to select a folder when configuring the ODBC data source. Dialog always takes me back to selecting a single file, even after selecting the correct network location. I am not sure if this is more of a tech support issue.

[Antonio]

Update: I just solved the issue. While the dialog did not work for me (firewall issues?), I made it work by modifying the Windows registry entry associated with the data source I was trying to create. I added a DBQ String value pointing to one of the .mdb files in the network location. After modifying it like that, and connecting to this data source, all the other files on the same folder as the one I selected show up as "catalogs" for this data source, so I can just select any of them.

Thank you.

[Kojiro Saito]

@Antonio

Thank you for the update. Happy to hear that the issue was solved.