February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Getting External Data
Introduction
If you need to temporarily exchange data between programs, copying and pasting or linking works the best. However, if you need to permanently exchange data, creating a connection to the data source is the best solution. A data source is a stored set of information that allows Excel to connect to an external database. A cell range, table, PivotTable report, or PivotChart report in Excel can be connected to an external data source.
External Data Sources
Microsoft allows you to retrieve data from several types of databases, including Microsoft Access, Microsoft Excel, Microsoft SQL Server, Microsoft SQL Server OLAP services, dBASE, Microsoft FoxPro, Oracle, Paradox, and text file databases. You can also retrieve ...