|
You can
connect Excel to many other sources including an SQL Server, an SQL
Analysis Service (such as the traffic data available from your
commercial website.)
An XML
file is data table of information. It is a table so there is a table
structure (the fields and the relationships) as well as the data.
Before
You Begin: Open
Legs Eggs Pigs with Macros 2010.xlsm
Macro-enabled spreadsheet. Download the
tblCustomers.xml
as well. The
example in the lesson uses a customer table that was created from a
table in Access.
1. Try This: Get External Data Go to a
blank sheet and select on Cell A1. Go to
Data ->Get External Data. Click on
From Other Sources. Click on
From XML Data Import. This will Open or map an XML file
into Excel. Keep
going...
Exam 77-888: Microsoft Excel Expert
2010
1. Sharing and Maintaining Workbooks
1.1. Apply workbook settings,
properties, and data options: Import XML data
Data ->Get External Data->From Other
Sources
|
|
| |
