Microsoft Excel 2013 Inside Out

Chapter 25. Working with external data

• Using and reusing Office Data Connections

• Opening an entire Access table in Excel

• Working with data in text files

• Working with XML files

• Using Microsoft Query to import data

• Using a web query to return Internet data

MICROSOFT EXCEL 2013 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 resides somewhere “outside”—on a server, on a website, in an XML file, or perhaps in a database program such as Oracle or Microsoft Access. Excel 2013 supports a wide variety of data formats, including SQL Server (and SQL Server Analysis Services), Access, dBase, FoxPro, Oracle, Paradox, and various kinds of text files. We’ll look ...