xml mapping in excel

Question

Hello

I'm trying to map XML data in Excel and I have followed the instructions listed on the following web-blog http://blogs.msdn.com/brian_jones/archive/2005/08/25/456298.aspx however it is not working for me, when i try to save or export it tells me that my map is not exportable...

this is the file that I am attempting to use as my 'map' and it must be exported in the format in order for me to use import it successfully into a database program that I am using...

<import type="financials" mode="Insert" startdate="2008-01-01" enddate="2010-01-01" importbudget="1" importexpenditures="1" importfundingsources="1" isfiscalmonth="0" searchmode="1">
<project name="TEST2" number="2">
<budgets>
<budgetcategory name="Other" type="" gl="" abbrev="">
<byear year="2009" amount="10.00">
</byear>
</budgetcategory>
</budgets>
<expenditures>
</expenditures>
<fundingsources>
<fundingsource name="FRP">
<fyear year="2009" amount="1000.00"/>
<fyear year="2010" amount="10000.00"/>
</fundingsource>
</fundingsources>
</project>
</import>

Can anyone tell me why this isn't working?

Thanks!!

Answer 1

Hi Candi7,

This forum provides support for documentation and interoperability questions on open specifications.
The Open Protocol Specifications can be found at: http://msdn2.microsoft.com/en-us/library/cc203350.aspx.
Your post does not appear to be related to the Open Protocols Specifications documentation set.

There are very helpful resources that may assist you to answer your question. I suggest the following:

Overview of XML in Excel: Working with XML maps
http://office.microsoft.com/en-us/excel/HA102063961033.aspx?pid=CH100648521033

Discussions in Office Developer General
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.office.developer.officedev.other&lang=en&cr=US

I would also suggest you consider searching these resources in case someone has already asked a similar question:
Microsoft TechNet
http://forums.microsoft.com/TechNet/default.aspx?SiteID=17
Microsoft MSDN Forums
http://social.msdn.microsoft.com/Forums/en-us/categories/

Thanks,
Edgar

Answer 2

thanks eh, i couldn't find an excel specific forum to post in and this one seemed alright. i guess not though

Answer 3

Hi Candi7,

You might also consider posting your question to the blog site. That may also helps.

Thanks,
Edgar