Chapter 4. Excel and External Data: Files, Databases, Cubes, and Data from the Internet
The real power of Excel is realized when it's connected to external data. This chapter explores in some detail the various data sources that are supported from within Excel 2007 using Office Data Connections. As an example, Excel's Text Import Wizard is so powerful that database experts often use it to bring miscellaneous data files into an Excel table where it's easy to work with data. You'll find out how to connect to Access, Oracle, and SQL Server; to OLAP cubes, which are a great source of hierarchically organized data; and even to web site data on the Internet using an Excel Web Query.
The following topics will be covered in this chapter:
Turning your ...
Get Microsoft ® Office 2007 Business Intelligence 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.
