March 2007
Intermediate to advanced
704 pages
21h 31m
English
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, ...
Read now
Unlock full access