Connect to MS access

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.

回答 (1 件)

Piyush Kumar
Piyush Kumar 2024 年 10 月 22 日

0 投票

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.

カテゴリ

製品

リリース

R2021a

質問済み:

2021 年 10 月 4 日

回答済み:

2024 年 10 月 22 日

Community Treasure Hunt

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

Start Hunting!

Translated by