Access link to particular view of a SharePoint List

I need to link to a SharePoint list from within Access and only retrieve the records for a particular view of the list.
It is not practical to pull down the entire list and then filter/SQL search within Access.
I want Access to only see the records in a particular view and only those columns in that view.

This is all working using Excel with a linked table and refresh all to update it from SharePoint I'd like to avoid the users
having to open a workbook at all  - just open access and the data is there (perhaps asking them if they want to refresh the data from SP)

I know to how directly link to a SharePoint list from Access - but that tries to bring down all records and all fields
(over 2000 records and 240 fields)  - not practical for end users.

I'm experienced in VBA, SharePoint, .. etc so a VBA solution is fine.
Environment:
Excel/Access 2016, SharePoint 2016, full control on the site w tons of workflows, JS, etc..
No infopath, No Access web apps, must work in FF and IE

so to summarize -
How to establish a link to a particular view of a SP list in access  - including refreshing etc
Specific examples, VBA code, ... sought
thanks
LVL 4
Keyboard CowboyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Keyboard CowboyAuthor Commented:
See https://docs.microsoft.com/en-us/office/vba/api/access.docmd.transfersharepointlist for a solution to this using docmd.transfersharepoint
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.