Page 7 of 12PREVNEXT

Import data: Filter external data before importing it into Excel

Selecting columns in Query Wizard

Fig. 1  The Query Wizard.
Fig. 2  The columns in the Employees table will be exported into Excel.

To open the Query Wizard, select the New Employee List DSN in the list and click OK.

Now you'll start creating a query, a set of questions you'll ask about data stored in the database. As we said at the beginning, you can use the Query Wizard to reduce the size of the data that you import into Excel. Import just the table(s) or part of a table you want, and sort the data before it is brought into Excel. This is where all that happens.

On the left side of the wizard is a list of all the available tables and columns from the database (see Figure 1). Click on the plus sign beside a table to see the columns in the table (see Figure 2). You move the columns you want to the right side (and then eventually into Excel) by clicking an arrow. You can choose part of table or an entire table.

Because this DSN is about employees, you'd expand the Employees table, and move the columns called LastName, FirstName, Title, HireDate, and Country to the right column. In this example, not all the columns in the table are moved to the right, so not all of the table data will be exported into Excel.

Page 7 of 12PREVNEXT