Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007 - Developer tab - xml import/export functions
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 developer tab | Excel Worksheet Functions | |||
Import/export netCDF files to Excel | Excel Discussion (Misc queries) | |||
Import/export excel macros between two computers | Excel Discussion (Misc queries) | |||
Excel 2007 Record Macro button in Developer tab is not highlighted | Excel Discussion (Misc queries) | |||
Add Visual Foxpro 9 DBF import / Export to Excel 2007 | Excel Worksheet Functions |