Hi, I am new to Monday.com. I have a number of datasets in Microsoft Access and wonder if it’s possible to integrate Access with Monday. So, Access retains the datasets but Monday can update the data, dynamically. Has this been done? thanks, JP
Hello @jennyp and welcome to the community!
I hope you like it here
That sounds interesting. You can access the information in your monday boards via our API.
So, on our end, you can both get data from the boards and update data in the boards as well.
Having said that, I have no experience with Microsoft Access. You would need to find a way to access the data in your database and send it to monday via API and to get the data to your database once you retrieve it from your boards.
Hope you can make it work! If you have further questions, you can always reach us at email@example.com
It would be great to see if other Monday users have achieved this with MS Access. Is there a development area specifically where these discussions might occur?
thanks again for your help,
I just moved the post to another section that will give it visibility to other devs so maybe someone can share their experience
That’s great, thanks Matias!
I have used VBA to accomplish this in Excel, but not Access. Here is a great intro to using API’s in VBA. It’s for Excel but I bet you could use it in Access too: Use Excel VBA to Read API Data - YouTube