Connect to MS access
9 ビュー (過去 30 日間)
古いコメントを表示
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"
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/757869/image.png)
- 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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/757879/image.png)
Thus, I don't know what to enter in the next menue and if I like to check the connection the check fails.
0 件のコメント
回答 (1 件)
Piyush Kumar
2024 年 10 月 22 日
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 件のコメント
参考
カテゴリ
Help Center および File Exchange で Database Toolbox についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!