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.
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 ...