CASE STUDY
You've volunteered to help out in a mayoral election—one of the candidates is your next door neighbor, so you suppress your distaste for the political process and offer your expertise in data management to your friend's election effort.
The campaign team has purchased a database containing voter rolls and it's up to you to help manage it. The first step is to get the data out of the database and into an Excel workbook where you can more easily analyze and summarize the information.
The data, shown in Figure 4.1, is in an Access database named Voters.mdb. The database is stored at C:\2005\CAMPAIGN.
Specifying the Data's Location and Format
You begin the first general step to importing data by choosing Data, Get External Data, New Database ...
Get Managing Data with Microsoft® Excel 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.
