Microsoft Office Tutorials and References
In Depth Information
The Web page appears
in the dialog box.
6
Click the elements you
want to appear in your
query.
A check mark indicates
you want to query an
element. An arrow
indicates you do not
want to query it.
l
7
Click Import.
6
7
The Import Data dialog box appears.
l
8
Click to select where you want to put the
imported data ( changes to ).
Choose from Existing Worksheet or New
Worksheet.
9
Click the cell address or type a range if
you selected Existing Worksheet.
8
9
0
Click OK.
The selected Web elements appear
within Excel, ready for analysis, charting,
and so on.
l
0
Did You Know?
To find statistical data on the Web, you can do a
Google search. You can download U.S. federal
statistics in multiple formats from the official
FedStats site at www.fedstats.gov/cgi-bin/A2Z.cgi.
State and municipal data is also available in great
abundance. You can find central access to this
material at the federal compendium, FirstGov,
which is available at www.firstgov.gov.
Did You Know?
A query definition is a file containing a definition
of the data you import into Excel from an external
source. The query definition indicates the data
source, the rows to include, how rows added to
the source are accommodated by the query, and
the frequency with which the data is updated. You
can view and modify query properties by clicking
the Data tab and then clicking Properties in the
Connections group.
Chapter 9: Extend Excel
199
 
Search JabSto ::




Custom Search