Connect to MS access

10 次查看（过去 30 天）
Jonas Metz
Jonas Metz 2021-10-4
回答： Piyush Kumar 2024-10-22
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
@Jonas Metz,
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.

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by