Page 4 of 12PREVNEXT

Import data: Filter external data before importing it into Excel

Import external data commands on Data menu; Choose Data Source dialog box

Fig. 1  On the Data menu, point to Import External Data, and then click New Database Query.
Fig. 2  The Choose Data Source dialog box.
Callout 1 Click New Data Source to create a new DSN file.
Callout 2 Or click another option in the list, such as MS Access Database, if you don't want to create a DSN file.

To start importing the names of employees hired this year, go to the Data menu. Point to Import External Data, and then click New Database Query (see Figure 1). That opens the Choose Data Source dialog box.

When the dialog box opens, you have two options (see Figure 2):

  • Click New Data Source and then click OK. This will create a new DSN file that you can reuse to connect to the same database again in the future if you want to.
  • Click MS Access Database, dBase files, or whatever is available in the list that you want to open. You might do this if you're connecting to a database for a one-time-only analysis and you don't need a reusable DSN file. You'll see in the practice steps at the end of the lesson how to do this.

Let's say that you do want to create a reusable DSN. You click New Data Source and then click OK.

Page 4 of 12PREVNEXT