R
Rick Allison
This a snippet of a much larger XSD
<xs:simpleType name="USStateType">
<xs:restriction base="xs:string">
<xs:enumeration value="AK"/> <!-- Alaska -->
<xs:enumeration value="AL"/> <!-- Alabama -->
<xs:enumeration value="AR"/> <!-- Arkansas -->
<xs:enumeration value="AZ"/> <!-- Arizona -->
<xs:enumeration value="CA"/> <!-- California -->
<xs:enumeration value="CO"/> <!-- Colorado -->
<xs:enumeration value="CT"/> <!-- Connecticut -->
<xs:enumeration value="DC"/> <!-- District of Columbia -->
<xs:enumeration value="DE"/> <!-- Delaware -->
<xs:enumeration value="FL"/> <!-- Florida -->
<xs:enumeration value="GA"/> <!-- Georgia -->
<xs:enumeration value="HI"/> <!-- Hawaii -->
<xs:enumeration value="IA"/> <!-- Iowa -->
<xs:enumeration value="ID"/> <!-- Idaho -->
<xs:enumeration value="IL"/> <!-- Illinois -->
<xs:enumeration value="IN"/> <!-- Indiana -->
<xs:enumeration value="KS"/> <!-- Kansas -->
<xs:enumeration value="KY"/> <!-- Kentucky -->
<xs:enumeration value="LA"/> <!-- Louisiana -->
<xs:enumeration value="MA"/> <!-- Massachusetts -->
<xs:enumeration value="MD"/> <!-- Maryland -->
<xs:enumeration value="ME"/> <!-- Maine -->
<xs:enumeration value="MI"/> <!-- Michigan -->
<xs:enumeration value="MN"/> <!-- Minnesota -->
<xs:enumeration value="MO"/> <!-- Missouri -->
<xs:enumeration value="MS"/> <!-- Mississippi -->
<xs:enumeration value="MT"/> <!-- Montana -->
<xs:enumeration value="NC"/> <!-- North Carolina -->
<xs:enumeration value="ND"/> <!-- North Dakota -->
<xs:enumeration value="NE"/> <!-- Nebraska -->
<xs:enumeration value="NH"/> <!-- New Hampshire -->
<xs:enumeration value="NJ"/> <!-- New Jersey -->
<xs:enumeration value="NM"/> <!-- New Mexico -->
<xs:enumeration value="NV"/> <!-- Nevada -->
<xs:enumeration value="NY"/> <!-- New York -->
<xs:enumeration value="OH"/> <!-- Ohio -->
<xs:enumeration value="OK"/> <!-- Oklahoma -->
<xs:enumeration value="OR"/> <!-- Oregon -->
<xs:enumeration value="PA"/> <!-- Pennsylvania -->
<xs:enumeration value="RI"/> <!-- Rhode Island -->
<xs:enumeration value="SC"/> <!-- South Carolina -->
<xs:enumeration value="SD"/> <!-- South Dakota -->
<xs:enumeration value="TN"/> <!-- Tennessee -->
<xs:enumeration value="TX"/> <!-- Texas -->
<xs:enumeration value="UT"/> <!-- Utah -->
<xs:enumeration value="VA"/> <!-- Virginia -->
<xs:enumeration value="VT"/> <!-- Vermont -->
<xs:enumeration value="WA"/> <!-- Washington -->
<xs:enumeration value="WI"/> <!-- Wisconsin -->
<xs:enumeration value="WV"/> <!-- West Virginia -->
<xs:enumeration value="WY"/> <!-- Wyoming -->
</xs:restriction>
</xs:simpleType>
How do you get it into a table, using Access 2003?
Thank you!
Rick
<xs:simpleType name="USStateType">
<xs:restriction base="xs:string">
<xs:enumeration value="AK"/> <!-- Alaska -->
<xs:enumeration value="AL"/> <!-- Alabama -->
<xs:enumeration value="AR"/> <!-- Arkansas -->
<xs:enumeration value="AZ"/> <!-- Arizona -->
<xs:enumeration value="CA"/> <!-- California -->
<xs:enumeration value="CO"/> <!-- Colorado -->
<xs:enumeration value="CT"/> <!-- Connecticut -->
<xs:enumeration value="DC"/> <!-- District of Columbia -->
<xs:enumeration value="DE"/> <!-- Delaware -->
<xs:enumeration value="FL"/> <!-- Florida -->
<xs:enumeration value="GA"/> <!-- Georgia -->
<xs:enumeration value="HI"/> <!-- Hawaii -->
<xs:enumeration value="IA"/> <!-- Iowa -->
<xs:enumeration value="ID"/> <!-- Idaho -->
<xs:enumeration value="IL"/> <!-- Illinois -->
<xs:enumeration value="IN"/> <!-- Indiana -->
<xs:enumeration value="KS"/> <!-- Kansas -->
<xs:enumeration value="KY"/> <!-- Kentucky -->
<xs:enumeration value="LA"/> <!-- Louisiana -->
<xs:enumeration value="MA"/> <!-- Massachusetts -->
<xs:enumeration value="MD"/> <!-- Maryland -->
<xs:enumeration value="ME"/> <!-- Maine -->
<xs:enumeration value="MI"/> <!-- Michigan -->
<xs:enumeration value="MN"/> <!-- Minnesota -->
<xs:enumeration value="MO"/> <!-- Missouri -->
<xs:enumeration value="MS"/> <!-- Mississippi -->
<xs:enumeration value="MT"/> <!-- Montana -->
<xs:enumeration value="NC"/> <!-- North Carolina -->
<xs:enumeration value="ND"/> <!-- North Dakota -->
<xs:enumeration value="NE"/> <!-- Nebraska -->
<xs:enumeration value="NH"/> <!-- New Hampshire -->
<xs:enumeration value="NJ"/> <!-- New Jersey -->
<xs:enumeration value="NM"/> <!-- New Mexico -->
<xs:enumeration value="NV"/> <!-- Nevada -->
<xs:enumeration value="NY"/> <!-- New York -->
<xs:enumeration value="OH"/> <!-- Ohio -->
<xs:enumeration value="OK"/> <!-- Oklahoma -->
<xs:enumeration value="OR"/> <!-- Oregon -->
<xs:enumeration value="PA"/> <!-- Pennsylvania -->
<xs:enumeration value="RI"/> <!-- Rhode Island -->
<xs:enumeration value="SC"/> <!-- South Carolina -->
<xs:enumeration value="SD"/> <!-- South Dakota -->
<xs:enumeration value="TN"/> <!-- Tennessee -->
<xs:enumeration value="TX"/> <!-- Texas -->
<xs:enumeration value="UT"/> <!-- Utah -->
<xs:enumeration value="VA"/> <!-- Virginia -->
<xs:enumeration value="VT"/> <!-- Vermont -->
<xs:enumeration value="WA"/> <!-- Washington -->
<xs:enumeration value="WI"/> <!-- Wisconsin -->
<xs:enumeration value="WV"/> <!-- West Virginia -->
<xs:enumeration value="WY"/> <!-- Wyoming -->
</xs:restriction>
</xs:simpleType>
How do you get it into a table, using Access 2003?
Thank you!
Rick