Import an XML document into an existing mapping

Microsoft Office Excel 2003

Show All Show All

Import an XML document into an existing mapping

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.

  1. Select a cell in the mapped range to which you want to import XML data.
  2. On the List toolbar, click Importbutton image.
  3. In the Look in list, click the drive, folder, or Internet location that contains the XML data file you want to import.
  4. In the folder list, locate and open the folder that contains the file.
  5. Click the file, and then click Import.

ShowTips

By default, existing data in a mapped range will be overwritten when you import data. Follow these steps if you want to append new data to the existing data when you import data:
  1. Select a cell in the mapped range.
  2. On the List toolbar, click XML Map Properties.
  3. Click Append new data to existing XML lists and then click OK.