Create a Web Service data connection

You can create an external data connection to a Web Service. For example, you can create a Web Service data connection to your enterprise Business Data Catalog and get business data.

After you create a Web Service data connection, you can link to it as you would any other external data source. If the Web Service accepts parameters, you can change the parameters when you create a linked table by using the Web Service data connection.

In this article

Overview

Create a connection to a Web Service

Link to an existing Web Service data connection

Overview

Microsoft Access 2010 lets you link to external data that is available through a Web Service. You must already have the Web Service connection file, which is supplied by the Web Service provider.The general process of using Web Service data is as follows:

  1. Obtain a Web Service data connection file.

  2. Install the Web Service data connection by using the connection file.

  3. Create a linked table by using the installed Web Service data connection.

Web Service linked tables are read-only

The linked tables that you create by using a Web Service data connection are read-only.

Top of Page

Create a connection to a Web Service

  1. On the ribbon, click the External Data tab.

  2. In the Import group, click Web Service.

  3. At the bottom of the Create Link to Web Service Data dialog box, click Install New Connection.

    Installing a Web Service data connection

  4. In the Select a connection definition file dialog box, browse to and select the XML file that contains the description of the Web Service.

    Note   This file is provided by the Web Service provider, or by your system administrator.

Top of Page

Link to an existing Web Service data connection

  1. On the ribbon, click the External Data tab.

  2. In the Import group, click Web Service.

  3. The Create Link to Web Service Data dialog box displays the tables of data that the Web Service provides. For example, if you connected to the AdventureWorks Web Service, you might see something like this:

    A Web Service data connection available for linking

  4. In the Create Link to Web Service Data, click the table that you want to use.

  5. Click Create Linked Table.

Specify a parameter value

Your Web Service data connection file may support parameters. A parameter is an expression that you use to filter data.

For example, the AdventureWorks Web Service data connection has an Orders table that can accept a value for Location, and use that value to limit the records that you can access by using the link.

Web Service data connection parameter

You set the parameter value for a Web Service data connection when you create the linked table.

  1. Follow the first four steps in the preceding procedure, Link to an existing Web Service data connection. Do not click Create Linked Table yet.

  2. In the Create Link to Web Service Data dialog box, specify the parameter value in the appropriate box in the parameter section. The interface that you see will vary somewhat depending on the Web Service data connection file that you use. Some connections support multiple parameters.

  3. When you are finished setting parameter values, click Create Linked Table.

Top of Page

Applies To: Access 2010



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language