O'Reilly logo

Microsoft ® Office 2007 Business Intelligence by Doug Harts

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

4.3. Importing Access Data into Excel 2007

It is amazing to see how much data resides in Access databases around the world. This makes sense when you realize that Access has been the de facto departmental database for many years now—and it is part of the Office suite of products. Excel 2007 makes it easy to connect to Access data, and we'll start with a direct connection to Access, as shown in Figure 4-20.

Figure 4-20. Excel 2007 get external data from Access
  1. Click the Get External Data icon, in the Connections menu group on the Ribbon menu Data tab.

  2. Click the From Access icon, in the Get External Data pop-up menu.

  3. Browse to any Access database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required