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

Retrieving Data with the Query Wizard

Querying data is the process of retrieving specific information from a database to create a list in an Excel worksheet. The Query Wizard lets you create a simple query to retrieve data in an external database and places that data in an Excel worksheet. You can also filter and sort data in the external database and place the imported data in an Excel worksheet.

The Query Wizard lets you use data from various external databases in your Excel worksheets. The wizard can establish links to various databases and use data query features to locate specific information. After this data is inside the Query Wizard, Excel can access the data for you whenever you need it.

Querying data in a database can be a complex process, ...

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