8.6. Viewing Data from External Sources in Excel Using a Data Connection

In all the Excel examples so far, the data for the cells have been entered directly into the cells of the worksheets. However, you can create Excel worksheets to display and manipulate data from external data sources. By external data sources, I am primarily referring to the use of databases such as Access and SQL Server. However, you can connect to many other data sources as well.

For this section, let's use the PUBS database for SQL Server 2005.

If you have Visual Studio, you can create the PUBS database for SQL Server 2005 from C:\Program Files\Microsoft Visual Studio ...

Get Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial