Chapter 3: Using External Data

When working with Excel, you often have situations when you have to import data from other applications into Excel. The most common are comma separated files (CSV) or some other form of delimitation.

In this chapter, we will cover how to import data from:

• A Microsoft Access database.
• A delimited text file, for example, a CSV file.
• A website with constantly changing live data, for example, Forex data.