Using Parameterized Web Queries
“Creating Parameterized Queries in Microsoft Query” earlier in this chapter showed how you can create queries that have one or more parameters. A parameter prompts you for a selection criterion that must be met by any records it returns to Excel.
Microsoft Office comes with some Internet query files, which have the filename extension .iqy. These queries also have parameters, which make them handy for returning from the Web information about companies you specify.
To use an Internet query, follow these steps:
1. |
Choose Data, Import External Data, Import Data. The Select Data Source dialog box appears as shown in Figure 18.21.
Figure 18.21. Use the Select Data Source window to invoke any existing database or Internet ... |
Get Business Analysis with Microsoft® Excel, Second Edition 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.
