Page 6 of 12PREVNEXT

Import data: Filter external data before importing it into Excel

Choose Data Source dialog box with New Employee List DSN

The DSN New Employee List is in the list of databases.

After you select the database you want, the Choose Data Source dialog box opens again.

The New Employee List DSN is now in the list in the Choose Data Source dialog box. You can reuse the DSN to connect to the list of employees anytime you want to. It will remain in the list until you remove it by selecting it and clicking the Delete button.

The next step is to select the DSN and use the Query Wizard to filter the data before you import it into Excel.

Page 6 of 12PREVNEXT