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. Office 2003 allows you to view, work with, and save XML files. You can also import and export XML data. Attach a Schema in Word -
| In Word, click the Tools menu, and then click Templates And Add-Ins. | -
| Click the XML Schema tab. | -
| Click Add Schema. | -
| Locate and select the XML schema file you want to attach, and then click Open . | -
| Select or clear a schema to attach or unattach it. | -
| Click OK. | Save or Export XML Data -
| Open the document, spreadsheet, or Access table you want to export. | -
| Click the File menu, and then click Save As or Export (in Access). | -
| Select a location where you want to save or export the XML data. | -
| Click the Save As Type list arrow, and then click XML Data or XML Spreadsheet (in Excel). | -
| Click Save. In Access, click Export, select an option, and then click OK. | Open and View an XML Data File -
| Click the File menu, and then click Open. | -
| Locate the XML file you want to open. | -
| Select the XML file. | -
| Click Open. | -
| In Excel, select an XML option. | -
As An XML List to create an XML list. -
As A Read-Only Workbook to open as a read-only file. -
Use The XML Source Task Pane to display the XML data in the XML Source task pane. -
| Click OK. | -
| To view the XML, click the View menu, click Task Pane, click the Other Task Panes list arrow, and then click XML Structure (in Word) or XML Source (in Excel). | Did You Know? You can import XML Data in Excel and Access . In Excel, select a cell in the mapped range to which you want to import XML data, click the Import button on the List toolbar, locate and select the XML file, and then click Import. There are additional XML commands on the XML submenu located on the Data menu. In Access, click the File menu, point to Get External Data, click Import, locate and select the XML file, and then click Import. | |