• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 22. Working with Your Database > Retrieving Data with the Query Wizard

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint