Microsoft Office Tutorials and References
In Depth Information
Importing External Data
Databases created and maintained with Microsoft Access are not, of course,
the only external data sources on which you can perform external data
queries. To import data from other sources, you click the From Other Sources
button on the Data tab or press Alt+AFO to open a drop-down menu with the
following options:
From SQL Server to import data from an SQL Server table
From Analysis Services to import data from an SQL Server Analysis cube
From Windows Azure Marketplace to import data from any of the
various marketplace service providers — note that you must provide the file
location (usually a URL address) and your account key before you can
import any marketplace data into Excel (visit www.windowsazure.com
for details on using this service)
From OData Data Feed to import data from any database table following
the Open Data Protocol (shortened to OData) — note that you must
provide the file location (usually a URL address) and user ID and password
to access the OData data feed before you can import any of its data into
Excel
From XML Data Import to import data from an XML file that you open
and map
From Data Connection Wizard to import data from a database table
using the Data Connection Wizard and OLEDB (Object Linking and
Embedding Database)
From Microsoft Query to import data from a database table using
Microsoft Query and ODBC (Open Database Connectivity)
For specific help with importing data using these various sources, see my
Excel 2013 All-In-One For Dummies .
Performing web queries
To make a web page query, you click the From Web command button on the
Data tab of the Ribbon or press Alt+AFW. Excel then opens the New Web
Query dialog box containing the Home page for your computer’s default web
browser (Internet Explorer 10 in most cases). To select the web page
containing the data you want to import into Excel, you can:
Type the URL web address in the Address text box at the top of the
Home page in the New Web Query dialog box.
Use the Search feature offered on the Home page or its links to find the
web page containing the data you wish to import.
 
Search JabSto ::




Custom Search