Excel 2007 - Developer tab - xml import/export functions

B

biz7

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!
 
B

biz7

Furthermore: 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top