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.

Answers (1)

Piyush Kumar
Piyush Kumar on 22 Oct 2024

0 votes

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.

Products

Release

R2021a

Asked:

on 4 Oct 2021

Answered:

on 22 Oct 2024

Community Treasure Hunt

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

Start Hunting!