Notifications
Announcements
Hi everyone, I've created an app that pulls data from a SharePoint List.
I'm looking for a way so that this update can be done manually. Anyone has any suggestion?
@MichaelNguyen
I assume you meant "automatically" versus "manually"?
There is not a connector for Access, so I would consider one of two options:
1) Devise a function in your Access database to push data to SharePoint as needed.
2) Move your data to SharePoint and use that as the record source in Access.
I hope this is helpful for you.
Hi @RandyHayes
Thanks a lot
Hmmm, I don't have any specific articles to site, but in general, if it was on my plate to deal with (besides moving to SharePoint for the Access data), I would consider writing some VBA code in the Access database that would either be manually selected or somehow automatically triggered, which would iterate through the access tables and then instantiate calls to SharePoint to add the records. Those last points I'd have to do more searching to find examples of (which there are), but then I could put something together like that.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 765 Most Valuable Professional
Michael E. Gernaey 343 Super User 2025 Season 2
Power Platform 1919 272
