Page 5 of 12PREVNEXT

Import data: Import external data into Excel 2003

Selecting a connection type, and then selecting an MS Access database as the data source in Data Connection Wizard

Fig. 1  Decide what type of connection to make in the first step of the Data Connection Wizard.
Fig. 2  Then decide what data source to connect to.

ODBC DSN is the most generic type of connection you can select in the wizard.

ODBC stands for Open Database Connectivity, which is a program file used to connect to a database. DSN stands for Data Source Name.

In the first step of the Data Connection Wizard, you select ODBC DSN as the connection type, and click Next (see Figure 1). You can then select from several types of databases, including dBase and Access.

Since the product data you want to import is stored in an Access database, you'd select MS Access Database in the list and click Next (see Figure 2).

You would then select the Access database you want to open, and select the table you want to open. Excel will name the resulting file, but you can pick another name. Then you import the data into Excel by clicking Finish in the final step.

You'll see exactly how to do these steps in the practice at the end of the lesson.

Reuse an .odc file

Once the .odc file is created, whenever you reopen the Select Data Source dialog box, this .odc file will be in the list of available data sources that you can open. You can reuse the .odc file to quickly connect to and import the same database table without going through the Data Connection Wizard.

Note     You can create as many .odc files as you need to the same database, one for each table. Be sure that the names are descriptive enough that you can tell them apart.

Page 5 of 12PREVNEXT