When You Need to Use External Data
When your source data isn’t in an Excel workbook, have no fear. It’s quite easy to import data from a number of sources, and even in many cases to keep that data linked to a dynamic source, so that it updates automatically when needed. Following is a summary overview of common data types you may want to import and related options. Find all of these options on the Data tab, in the Get External Data group.
When you import data from a Microsoft Office Access 2007 database, you select the database that contains your source data and Excel prompts you to select a table within that database, if it contains multiple tables. Once you select the data source, you get the option to import the data into a table, PivotTable, ...
Get Advanced Microsoft® Office Documents 2007 Edition Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
