Name

Data Get External Data

Synopsis

The Data Get External Data submenu options provide the ability to get data from different non-Excel sources and place it in your worksheet. You can get data from different databases using queries. This option is useful for database file types that Excel cannot open or ones that are too large to open. You can also create queries to gather data from a web site.

Note

When you create and run a database query you are actually using Microsoft Query. This is a separate program that must be installed on your system. If it is not installed, when you run Data Get External Data New Database Query you will be prompted to install it by rerunning the setup program for either Excel or Microsoft Office.

Run Saved Query

This option provides the ability to run a previously saved query. When you select this option the Run Query dialog displays as shown in Figure 9-36. You can select from both web and database queries.

Run Query dialog

Figure 9-36. Run Query dialog

Note

The options available on this dialog are the same as the Open dialog that displays when you select File Open.

When you select the Get Data button Excel displays the “Returning External Data to Microsoft Excel” dialog, as shown in Figure 9-37. This dialog allows you to specify the location where you want to place the results of the query.

Figure 9-37. Returning External Data to Microsoft Excel dialog

By default Excel ...

Get Excel 2000 in a Nutshell 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.