Page 2 of 12PREVNEXT

Import data: Import external data into Excel 2003

Using Data Connection Wizard to import data into Excel

Use the Data Connection Wizard to import data into Excel.

Suppose you want to do some analysis of all the products sold by your company. For example, how are certain products selling in comparison to others, what are the costs of selling each product, and what is the sales volume of each product compared to last year?

The data is stored in an Access database, but you want to use Excel to analyze it. Use the Data Connection Wizard to get the data into Excel.

To continue reading this lesson on your own, click Next.

Page 2 of 12PREVNEXT