XML (Extensible Markup Language) is a universal language that enables you to create documents in which data is stored independently of the format so you can use the data more seamlessly in other forms. XML is fully supported in Office 2003 through Word, Excel, and Access. XML allows you to work with the familiar Office interface and create and save documents as XML, without ever knowing the XML language. When you work with XML, you can attach an XML Schema ”a set of rules that defines the elements and content used in an XML document. XML schemas are created by developers who understand XML. After you attach a schema, you need to map the schema elements to cells in your worksheet. When the mapping is complete, you can import the XML data related to the XML schema to populate the worksheet. Attach a Schema -
| Click the Data menu, point to XML, and then click XML Source. | -
| Click XML Maps. | -
| Click Add. | -
| Locate and select the XML schema file you want to attach, and then click Open. | -
| If necessary, click OK to create a schema based on the XML source data. | -
| To delete or rename an XML schema, select the schema, and then click Delete or Rename. | -
| Click OK. | -
| When you're done, click the Close button on the task pane. | Did You Know? You can change XML view options . In the XML Source task pane, click Options to turn on or off options to preview data in the task pane, hide help text in the task pane, automatically merge elements when mapping, include data heading, and hide border of inactive lists. | Create an XML Data Map -
| Open the worksheet in which you want to map the XML data. | -
| Click the Data menu, point to XML, and then click XML Source. | -
| Click the Map Name list arrow, and then click the XML schema you want to use. | -
| Drag the named elements from the XML Source task pane to the corresponding cells in the worksheet. | -
| When you're done, click the Close button on the task pane. | Did You Know? You can change XML map properties . Click the Data menu, point to XML, click XML Map Properties, select or clear the check boxes options you do or don't want, and then click OK. | Import XML Data -
| Open the worksheet in which you want to map the XML data. | -
| Click the Data menu, point to XML, and then click Import. | -
| Click the Files Of Type list arrow, and then click XML Files. | -
| Locate, and then select the XML data file you want to import. | -
| Click Import. | |