Chapter 25. Working with external 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 ...

Get Microsoft Excel 2013 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.