View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
biz7 biz7 is offline
external usenet poster
 
Posts: 5
Default Excel 2007 - Developer tab - xml import/export functions

Furthermo When i select Source/ "Verify Map for Export": it states
[["Denormalized data. A mapped element's relationship with other elements
cannot be preserved"]]. This is disappointing because I assume if you can
import than you can export the XML. How can I fix this? Thanks.

Microsoft Help states: Denormalized data An XML table contains an element
that has been defined in the schema to occur once (the maxoccurs attribute is
set to 1). When you add such an element to an XML table, Excel fills the
table column with multiple instances of the element.



"biz7" wrote:

Hello:

I exported an xml file from an application called Wall Street Office
(microsoft sql-based).

I have just installed Microsoft Excel 2007 where I can select Developer &
import the XML file. I was testing the export functionality & have not made
any updates. When I click on export on the Developer tab, it gives me this
message: "XML maps in my workbook are not exportable."

I click on Help & all that information is foreign language to decipher what
i need to do. Can you help me? This is for a work project. thanks!