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 the O’Reilly learning platform.

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