DoCmd.TransferSharePointList (Access)

You can use the TransferSharePointList method to import or link data from a SharePoint Foundation site.

This method has the same effect as choosing SharePoint List in the Import group on the External Data tab. The arguments for the action correspond to the choices you make in the Get External Data Wizard. If you specify a nonexistent list or view, no error occurs, and no data is transferred. A GUID is a unique hexadecimal identifier for a list or a view. A GUID must be entered in the following format, where each "F" is a hexadecimal number (0 through 9 or A through F).

TransferSharePointList (TransferType, SiteAddress, ListID, ViewID, TableName, GetLookupDisplayValues)

{FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF}

Arguments

The following arguments are required:

TransferType (AcSharePointListTransferType) - An AcSharePointListTransferType constant that specifies the type of transfer to make.

Possible return values are acImportSharePointList - Import the SharePoint list, acLinkSharePointList - Link to the SharePoint list.

SiteAddress (String) - The full path of the SharePoint site.

ListID (String) - The name or GUID of the list to be transferred.

Optional arguments

The following arguments are optional

ViewID (String) - The GUID of the view for the list that you want to use. Leave this argument blank to transfer all rows and columns in the list.

TableName (String) - The name you want displayed for the table or linked table in Access.

GetLookupDisplayValues (Boolean) - Specifies whether to transfer display values for Lookup fields instead of the ID used to perform the lookup.