Connect to MS access
7 views (last 30 days)
Show older comments
I have a MS access file (32-bit version), which lies on in the company network. I'd like to access it via matlab. I read that I should use the "Database Explorer", however, I can not manage it. Here is what I do:
- Open DataBase Explorer
- Click on "Configure Data Source" --> "Configure OBDT data source"
- Choose the sheet "User-DSN", select "MS Access Database", and click on "Add ..."
- In the "New data source" window I am only allowed to choose a sql server, which is probably wrong
Thus, I don't know what to enter in the next menue and if I like to check the connection the check fails.
0 Comments
Answers (1)
Piyush Kumar
on 22 Oct 2024
Check this link. It shows how to set up a data source and connect to a Microsoft Access database using the Database Explorer app or the command line.
0 Comments
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!