Programatically Link to SharePoint List Table (1 Viewer)

[crocket]

Hello,

It's been over 9 years since I've programmed with Access, so I'm glad to see that this forum is still around and going strong.

Can someone point me in the right direction to help me get started with this? What I'd like to do is create a generic Access form that allows the user to paste the URL of their SharePoint list in a text box.

Example: MySharePointSite.com/sites/projects/MyProject/MySharepointList.aspx

The code then links to the table that houses the data for the SharePoint list. Once the table connections has been made, the user will select the fields for the data they want to export to a file. They will not be creating/modifying tables or adding/editing data.

First of all, is this even possible? I've had to manually link to the SharePoint list.

Thanks!

 

[Isaac]

I've used code like this recently to link to a sharepoint list:

dim strSPSite as String, strSPListName as string

strSPListName = "IsaacTestList"
strSPSite = "https://something.something.something.com/sites/sitename"
DoCmd.TransferSharePointList 1, strSPSite, strSPListName, , "Sharepoint"