O'Reilly logo

Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours by Trudi Reisner

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

Choosing a Data Source

To use Microsoft Query, choose Data, Import External Data, New Database Query. The Choose Data Source dialog box appears, as shown in Figure 22.9.

Figure 22.9. The Choose Data Source dialog box.

The first step involved in using the Query Wizard is choosing a data source on the Databases tab. This item is the database driver that Excel uses to access the data. The database driver can be any of the following:

  • dBASE Files (*.dbf)

  • Excel files (*.xls)

  • MS Access Database (*.mdb)

After you select a database driver, click OK. The Select Database dialog box opens. Navigate to the folder that contains the database, select the database ...

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