Re: XML to Excel

- permitinfo - permit - permitdetail statusApproved/status areanameNorthern Utah/areaname descriptionGarage/description numberHON07032905/number date03/29/2007/date value22000/value /permitdetail /permit - permit - permitdetail statusApproved/status areanameNorthern

RE: XML to Excel

In excel, you get a prompt: the specified xml source does not refer to a schema. Excel will create a schema based on the xml source data. Can I somewho provide that schema automatically? Sure: permitinfo xmlns:xsi= http://www.w3.org/2001/XMLSchema-instance;

Re: XML to Excel

Dave, THank you. That is what I was looking for. I think I can figure it out from here. I need to learn xslt and all that, but I was stuck trying to figure out how to get that info in there using the CFXML tag. Easy as inserting it in my root element as per your example. Thanks again, off to

RE: XML to Excel

I want to make an xml file available to my clients that they can easily import into excel. I can generate the xml file no problem and it imports into excel pretty good, but some of the date fields give the little exclamation mark, because excel doesn't know them to be date fields. Do

Re: XML to Excel

XMLTransorm() takes some XML and applies an XSLT Stylesheet to it, returning the transformed XML. An XSLT transformation will always output another XML document so XMLTransform() is not what you need. A schema is a set of rules for a particular flavour of XML for it to validate against. I.e.