About XML data bindings

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

An XML data binding is created when you perform any of the following actions:

• Import the contents of an XML data file into an existing XML mapping.
• Use a Data Retrieval Service Connection (.uxdc) file to connect to a data source.

XML Data Binding Guidelines

Some facts that you should know about XML data bindings are:

• An XML map can only have one XML data binding.
• An XML data binding is bound to all of the mappings that have been created from a single XML map.

Refresh an XML Data Binding

Click Refresh on the List toolbar to import the latest data from the data source.

Control Refresh Behavior

The XML Map Properties dialog box contains settings that relate to an XML data binding. Click XML Map Properties on the List toolbar to display the XML Map Properties dialog box.

The following settings in the XML Map Properties dialog box relate to XML data bindings:

Validate data against schema for import and export    This option specifies whether Excel validates data against the XML map when importing or exporting data. This option is disabled by default.

Save data source definition in workbook    Clearing this check box removes the XML binding from the workbook. Clearing this option does not delete any data from the worksheet. This option is enabled by default.

Overwrite existing data with new data    Existing data is overwritten with newly returned data. This option is enabled by default.

Append new data to existing XML lists    The contents of the data source are appended to the existing data on the worksheet. This option is disabled by default.