4.2. Importing Data from a Text File into Excel 2007
Figure 4-1 shows a real-world text file, opened in Notepad. This is information from swim teams that lists team names and dates for competition. Looking at it in Notepad, we can see valuable data, but it's not organized or formatted in any usable manner. It makes sense that if we can easily import the text file into Excel, we could then arrange and list the swim teams and schedules in a coherent manner.
4.2.1. The Truth about Importing Data
Our text file is a simple example of data that we have all around us in the real world. It is a single file of swim team information (important to the swim team participants!), but working with it will help us see the Excel 2007 Data Connection and Import ...
Get Microsoft ® Office 2007 Business Intelligence 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.
