Microsoft® Office Excel 2003 Inside Out

Chapter 29. Working with External Data

• Using File, Open to Import External Data Files

• Working with XML Files

• Using a Query to Retrieve External Data

• Using a Web Query to Return Internet Data

Microsoft Excel is a superb tool for analyzing data, but before you can do any analysis, you have to get the data into Excel. In many cases, the information you need to work with resides somewhere "outside"—in a mainframe text file, on a Web site, in an XML file, or in a database program such as Oracle or Microsoft Access. Excel provides excellent tools for importing that information onto your worksheets; those tools are the subject of this chapter.

Using File, ...