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, ...
Get Sams Teach Yourself Microsoft® Office Excel 2003 in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
