I know the steps for the manual process, but is there a VBA way to import SharePoint list(s) into an access database?
I know the steps for the manual process, but is there a VBA way to import SharePoint list(s) into an access database?
Bing: Access VBA import SharePoint list
https://anvlpopescu.wordpress.com/20...rosoft-access/
Docmd.TransferSharePointList
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
In the Dcmd.TransferSharePointList where are these values pulled from?Bing: Access VBA import SharePoint list
https://anvlpopescu.wordpress.com/20...rosoft-access/
Docmd.TransferSharePointList
Code:"{A92FF376-FC2E-4390-BB03-CC47C756EB08}", "{F1AA137A-7C97-4C89-AB79-31447B77545C}"
I have never used SharePoint and have no idea.
Did you view the additional link referenced in the one I posted? [removed link that won't work from here, it does work in the above referenced page]
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
That link generates a 404 error. Easy enough to get to the right page from the first link you provided where it says the method "is well documented here"
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
That's odd. Never encountered this before.
Doubly odd because when I copy/paste to another browser window, it works.
I removed the link from post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
It states it's the list id and view id of SharePoint. I'll have to google to determine how to get that information, but thanks for the link!