Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Excel 2007 - Developer- XML import/export functions

5 views
Skip to first unread message

biz7

unread,
Jun 26, 2009, 2:46:01 PM6/26/09
to

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 tab &
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!

biz7

unread,
Jun 26, 2009, 3:29:01 PM6/26/09
to

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.

0 new messages