DoCmd.TransferSharePointList method (Access)

Use the TransferSharePointList method to import or link data from a SharePoint Foundation site.

Syntax

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

expression A variable that represents a DoCmd object.

Parameters

Name Required/Optional Data type Description
TransferType Required AcSharePointListTransferType An AcSharePointListTransferType constant that specifies the type of transfer to make.
SiteAddress Required Variant The full path of the SharePoint site.
ListID Required Variant The name or GUID of the list to be transferred.
ViewID Optional Variant 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 Optional Variant The name you want displayed for the table or linked table in Access.
GetLookupDisplayValues Optional Variant Specifies whether to transfer display values for Lookup fields instead of the ID used to perform the lookup.

Remarks

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).

{FFFFFFFF-FFFF-FFFF-FFFF-FFFFFFFFFFFF}

You can obtain the GUID for a list or view from the SharePoint site by using the following procedure:

  1. Open the list in SharePoint Foundation.

  2. If the view you want is not displayed, click the View drop-down arrow, and then select the view that you want.

  3. Choose the View drop-down arrow and then select Modify this View. The address in the browser's address bar contains the GUIDs for both the list and the view. The GUID for the list follows List=, and the GUID for the view follows View=. However, in the address, each { (left brace) character is represented by the string %7B, each - (hyphen) character is represented by the string %2D, and each } (right brace) character is represented by the string %7D. For example:

    https://MySite12/_layouts/ViewEdit.aspx?List=%7B2A82A404%2D5529%2D47DC%2DAE13%2DAC1D9BC0A84F%7D&View=%7B357B4FE6%2D44CF%2D4275%2DB91F%2D46558301579B%7D

    Before you can use the GUIDs from the address as arguments in this macro action, you must replace each %7B string with the { character, replace each %2D string with the - character, and replace each %7D string with the } character. Do not include the & (ampersand) character that follows the %7D string in the list GUID.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.