Microsoft Access 2010 Bible

Part III: More-Advanced Access Techniques

586

FIGURE 16.2

A query using externally linked tables

Local Access table Linked Excel worksheet

Linked Access table Linked Excel worksheet

This query shows the potential benefit of linking to a variety of data sources and seamlessly dis-

plays data from internal and linked tables. Figure 16.3 shows the datasheet returned by this query.

Each column in this datasheet comes from a different data source.

FIGURE 16.3

The datasheet view of externally linked data