Thanks for the help, I ended up not using XML, I am still curious to see an example.
This is too advanced for me.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcreatingclientsthatparsecontentofotherwebpages.asp






"John Sitka" <johnsitka@R...> wrote in message news:eI2nvBZgFHA.3256@T......
> Progress....
>
> Paste HTML table into Excel
>
> Utilize the XML_Toolbox to build XSD schema
> use the sequence option, get the schema
>
> <?xml version='1.0' encoding='UTF-8'?>
> <xsd:schema targetNamespace="http://tempuri.org/XMLSchema.xsd" elementFormDefault="qualified" 
> xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://tempuri.org/XMLSchema.xsd">
> <xsd:annotation>XSD Schema generated with Excel XML Toolbox</xsd:annotation>
> <xsd:element name="Root" type="RootType"/>
> <xsd:complexType name="RootType">
>  <xsd:all>
>   <xsd:element name="items" type="itemsType" minOccurs="0"/>
>  </xsd:all>
> </xsd:complexType>
> <xsd:complexType name="itemsType">
>  <xsd:sequence>
>   <xsd:element name="item" minOccurs="0" maxOccurs="unbounded">
>    <xsd:complexType>
>     <xsd:sequence>
>      <xsd:element name="NO" type="xsd:double" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="SOURCE" type="xsd:string" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="QTY" type="xsd:double" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="DESCRIPTION_NAME" type="xsd:string" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="SIZE_CAT__" type="xsd:string" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="DATE_REQ_D" type="xsd:string" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="Sht__" type="xsd:double" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="O_M" type="xsd:string" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="CUST_STD__" type="xsd:string" minOccurs="0" nillable="true" form="qualified"/>
>      <xsd:element name="DATE" type="xsd:dateTime" minOccurs="0" nillable="true" form="qualified"/>
>     </xsd:sequence>
>    </xsd:complexType>
>   </xsd:element>
>  </xsd:sequence>
> </xsd:complexType>
> </xsd:schema>
>
> Then once that is there you can save as an XML file.
> with proper element markup. Now with this schema I can see how maybe moving
> on and attempting to use a .NET class to automate the XML file generation
> But XslTransform? Hope there is an XsdTransform?
>
> Thanks for the chatter
>
>
>
>
>
>
>
> "John Sitka" <johnsitka@R...> wrote in message news:eFDEDhYgFHA.3608@T......
>> Sorry folks none of this is making sense right now.
>> So I get a well formed document that ....
>>
>> Example I take the table to Excel and save as XML
>>
>> That gets me complex element types <ROW
>> with child elements <CELL but that isn't the data definition I need
>> Those are just positional references. I need the header columns as the
>> element names. So what is the tool that I need to use to
>> build that definition. Excel says add a Map but they are looking for
>> dynamic data sources. Mine is static it will bee the HTML table itself.
>> I'm gonna try a empty table as a tempate and see if that works.
>>
>>
>>
>> "Patrick Philippot" <patrick.philippot@m...> wrote in message news:%23hJVTMYgFHA.3936@t......
>>> Martin Honnen wrote:
>>>>> How do I convert it to XML? Not just so it is valid, but so the
>>>>> first row are the element definitions.
>>>>
>>>> You need an SGML parser to parse HTML, then you can extract the
>>>> information as needed, it seems you are only interested in the table
>>>> in the body so you could extract that.
>>>> .NET has an SGMLReader class that you could use with .NET to parse
>>>> HTML.
>>>
>>> You can also look at the HTML Agility Pack:
>>> http://smourier.blogspot.com/
>>>
>>> -- 
>>> Patrick Philippot - Microsoft MVP
>>> MainSoft Consulting Services
>>> www.mainsoft.fr
>>>
>>
>>
>
>