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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.