O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Chapter 29. Working with External 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, ...

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