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

Chapter 18. Importing Business Data into... > Using Parameterized Web Queries

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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