Excel® 2013 On Demand

Getting Query Data from a Database

If you have data in a database, you can use functions in Excel to retrieve data from a table in a database. To retrieve the data, you can select or create a data source, build a query to create a link to the data, and optionally, create a filter to limit the information. When you select or create a data source, you need to identify the database type and then connect to it. To build a query, you can use the Query wizard to step you through the process, or you can manually create a query the same way you do in Microsoft Access. You can also retrieve data from other sources. If you use the same table in a database for data, you can define and save the data source for use later.

Define a New Data Source

Click ...