Can we access MS Access form fields through MATLAB?

I want to access MS Access form fields to enter data one by one. Can it is possible through MATLAB? If yes please guide me for the same. What are the different ways to Access form fields of MS Access?

Answer 1

[Walter Roberson]

You will need to connect to an activex control, or you will need to use a .NET facility. Or possibly you can find a Perl or Python or Java library that you can call, or some C or C++ DLL.

MATLAB does not have any direct interface to Excel or Access that would allow to do these things.

[Prajwaali Dholle]

Thank you Walter!

[Prajwaali Dholle]

Can we modify the data base present in MS Access using GUI? Can you guide me with this?

Answer 2

[Image Analyst]

See if you can record a macro in Access. Then look at it to see what ActiveX commands you need to send to MATLAB.

I'm attaching a demo for Excel. Adapt it for MS Access.