Microsoft Office Tutorials and References
In Depth Information
Connecting to Data
Creating Data Connection Libraries
To create a new DCL in SharePoint, open the Site Actions menu, select Create, and then click Data
Connection Library. Fill in the Name, Description, and other properties of the document library.
In the Document Template field, select None. When you use the Report Center Web template to create a
new site, a DCL is created by default on the site.
There are two main ways to add connections to a DCL: uploading them through SharePoint and
publishing them from Excel. Uploading is done in the same way as with any other file in a document library. Select
Upload Document or Upload Multiple Documents from the Upload menu of the DCL, and then browse to
the documents you want to upload.
From Excel, if you have sufficient permissions, you can publish an existing connection from a workbook
to a DCL. In the Data Ribbon of Excel 2007, click Connections and select the connection you want to
publish from the list. Click the Properties button to open the Connection Properties dialog box and select
the Definition tab. Then, click the Export Connection File button to choose the DCL folder you want to
publish to, and click Save. You can set the metadata properties of the file (such as its description and
keywords) to allow users to find the right connection quickly. Figure 5-3 shows the Excel dialog boxes
for publishing connections.