Microsoft Office Tutorials and References
In Depth Information
Importing External Data
When you have the web page containing the data you want to import
displayed in the New Web Query dialog box, Excel indicates which tables of
information you can import from the web page into the worksheet by adding
a yellow box with an arrowhead pointing right. To import these tables, you
simply click this box to add a check mark to it (see Figure 11-11).
Figure 11-11:
Selecting
the table
of data to
import on
the Yahoo!
Finance
web page.
After you finish checking all the tables you want to import on the page, click
the Import button to close the New Web Query dialog box. Excel then opens
a version of the Import Data dialog box with only the Table option available
where you can indicate where the table data is to be imported by selecting
one of these options:
Existing Worksheet (default) to have the data in the Access data table
imported into the current worksheet starting at the current cell address
listed in the text box
New Worksheet to have the data in the Access data table imported into
a new sheet that’s added to the beginning of the workbook
After you click OK in the Import Data dialog box, Excel closes the dialog box
and then imports all the tables of data you selected on the web page into a
new worksheet starting at cell A1 or in the existing worksheet starting at the
cell whose address was entered in the text box in the Import Data dialog box.
Excel brings this data from the Volume Leaders table on the Yahoo! Finance
web page into the worksheet as cell ranges rather than as an Excel Table.
If you then want to be able to sort or filter this imported financial data, you
need to select one of its cells and then select the Format as Table button on
 
Search JabSto ::




Custom Search