Connect to MS access

7 views (last 30 days)
Jonas Metz
Jonas Metz on 4 Oct 2021
Answered: Piyush Kumar on 22 Oct 2024
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
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

Community Treasure Hunt

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

Start Hunting!