• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 9: Managing Databases and Lists > Working with External Data

Chapter 29. Working with External Data

Using File, Open to Import External Data Files 757

Working with XML Files 762

Using a Query to Retrieve External Data 767

Using a Web Query to Return Internet Data 790

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint