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.
You can use built-in triggers, custom triggers, built in actions, custom actions. and webhooks to make this work.
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 appsupport@monday.com 💪
Cheers,
-Matias
Thanks Matias,
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,
Jenny
Hey @jennyp!
I just moved the post to another section that will give it visibility to other devs so maybe someone can share their experience 🙂
Cheers,
-Matias
That’s great, thanks Matias!
Jenny
Hi Jenny,
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
Reply
Login to monday.com
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.