Unable to do XML export from Excel 2003 - XML SOAP

This is a discussion on Unable to do XML export from Excel 2003 - XML SOAP ; I get a message saying "Cannot save or export XML data. The XML maps in this workbook are not exportable." I have a multi-column Excel 2003 file and am trying to export three of the columns to XML. It worked ...

+ Reply to Thread
Results 1 to 3 of 3

Unable to do XML export from Excel 2003

  1. Default Unable to do XML export from Excel 2003

    I get a message saying "Cannot save or export XML data. The XML maps in this
    workbook are not exportable."

    I have a multi-column Excel 2003 file and am trying to export three of the
    columns to XML. It worked two weeks ago and I've just added an extra
    repeating child element (with a date in the format dd/mm/yyyy).

    Thanks

    Marcus
    Hong Kong




  2. Default Re: Unable to do XML export from Excel 2003

    Hi Marcus,

    An XML mapping cannot be exported if the mapped element's relationship with
    other elements cannot be preserved. This relationship may not be preserved
    for the following reasons: The schema definition of a mapped element is
    contained within a sequence with the following attributes:
    a. The maxoccurs attribute is not equal to 1.
    b. The sequence has more than one direct child element defined, or has
    another compositor as a direct child.
    c. Non-repeating sibling elements with the same repeating parent element are
    mapped to different XML lists.
    d. Multiple repeating elements are mapped to the same XML list, and the
    repetition not defined by an ancestor element.
    e. Child elements from different parents are mapped to the same XML list.

    HTH,
    Anushi




    "Marcus Crowley" <marcus@pacificconnections.com> wrote in message
    news:ePTGKbD0EHA.2540@TK2MSFTNGP09.phx.gbl...
    > I get a message saying "Cannot save or export XML data. The XML maps in

    this
    > workbook are not exportable."
    >
    > I have a multi-column Excel 2003 file and am trying to export three of the
    > columns to XML. It worked two weeks ago and I've just added an extra
    > repeating child element (with a date in the format dd/mm/yyyy).
    >
    > Thanks
    >
    > Marcus
    > Hong Kong
    >
    >
    >




  3. Default Re: Unable to do XML export from Excel 2003

    In order to export Access data to an XML file, follow the steps:

    Step 1:
    Click on the External Data Ribbon, then choose Export More XML File

    Step 2:
    Access will ask for the path to store the XML file. It will provide option to browse to the location to choose the path and name the XML file.

    Step 3:
    This involves the step to choose the file type. By defualt access provides 3 file types. Namely
    Data (XML) – creates a XML file with all the content of all the records in the table as selected.
    Schema (XSD) – it doesn't contain any data, but stores the definition which describes the selected table.
    Presentation (XSL) – defines how a browser can convert the data in the XML file into HTML web page (which displays normally online).

    If one wants to export the related tables as well one can select the more option on this screen.Here in our example we choose the first option [Data(XML)].

    Step 4:
    Click on OK to generate the XML file.

    Step5:
    If some one wants to repeat this same process without going through the wizard once again, then they can do so by checking the option "Save Export Steps".

    Eliza
    Cheers,
    Eliza

+ Reply to Thread

Similar Threads

  1. Problem with Excel reports ::::Excel 2003 Migration To Excel 2007
    By Application Development in forum DOTNET
    Replies: 15
    Last Post: 10-24-2007, 08:34 AM
  2. Export to excel in asp.net using excel template
    By Application Development in forum DOTNET
    Replies: 4
    Last Post: 10-17-2007, 03:08 AM
  3. Replies: 3
    Last Post: 03-03-2006, 08:54 AM
  4. Replies: 0
    Last Post: 03-02-2006, 05:49 AM
  5. Excel 2003 Export XML with xsi:noNamespaceSchemaLocation
    By Application Development in forum XML SOAP
    Replies: 0
    Last Post: 08-11-2005, 10:23 PM