Microsoft Office Tutorials and References
In Depth Information
Understanding External Data
Chapter 7: Importing Data into Excel
Web Page
People and companies often store useful data
on Web pages that reside either on the
Internet or on company intranets. This data is
often a combination of text and tables, but
you cannot analyze Web-based data in any
meaningful way in your Web browser.
Fortunately, Excel enables you to create a Web
query that lets you import text and tables from
a Web page. For more information, see the
section, “Import Data from a Web Page.”
XML
XML — Extensible Markup Language — is
redefining how data is stored. This is reflected
in the large number of tools that Excel now
has for dealing with XML data, particularly
tools for importing XML data into Excel. For
more information, see the section, “Import
Data from an XML File.”
Access to External Data
To use external data, you must have access to
it. This usually means knowing at least one of
the following: the location of the data or the
login information required to authorize your
use of the data.
Location
To access external data, you must at least
know where it is located. Here are the most
common possibilities: in a file on your
computer; in a file on your network; on a
network server, particularly as part of a large,
server-based database management system,
such as SQL Server or Oracle; on a Web page;
and on a Web server.
Login
Knowing where the data is located is probably
all that you require if you are dealing with a
local file or database or, usually, a Web page.
However, after you start accessing data
remotely — on a network, database server, or
Web server — you will also require
authorization to secure that access. See the
administrator of the resource to obtain a
username or login ID as well as a password.
 
Search JabSto ::




Custom Search