O'Reilly logo

Microsoft ® Office 2007 Business Intelligence by Doug Harts

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required