Connect to MS access

7 visualizaciones (últimos 30 días)
Jonas Metz
Jonas Metz el 4 de Oct. de 2021
Respondida: Piyush Kumar el 22 de Oct. de 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.

Respuestas (1)

Piyush Kumar
Piyush Kumar el 22 de Oct. de 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.

Etiquetas

Productos


Versión

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by