MartyConnelly
martyconnelly at shaw.ca
Fri Nov 3 19:24:35 CST 2006
Here is another VB.Net variation that might help How Do I...Read XML from an XmlDataDocument? http://samples.gotdotnet.com/quickstart/howto/doc/Xml/StreamXmlDocument.aspx I think by rewriting the FormatXML function you could generate Entity only XML file Greg Smith wrote: > (This is a second resend - my first one was html to illustrate the color >layout for ease of reading the XML, but it turns out to be too large, so >here it is in text only format) > >Hi everyone! It's been a while, or seems like it anyway! Hope everyone is >well. > >Below is a valid XML file, according to the shown DTD, except for the part >inside the <Docmuent> elements, which is normally image in b64 code, but >unnecessary for this example. > >I know that Access does not like attribute-centric XML and will not import >it (correctly). I know that it DOES like element-centric XML and WILL >import that. I think (which can be dangerous) that what I have below is >attribute-centric, or some version of it, because, looking at examples from >Microsoft of element-centric XML, this does not look like it. However, >looking at Microsoft's attribute-centric XML, it doesn't look like that >either. Closer, but not like this. > >What I really need to do is import the data from this file into Access (I'm >using 2003). Now, I could just read the file as a text file, and strip out >what I want, but that's not terribly efficient and might prove difficult to >do when there are duplicated element names or attribute fields. > >Ideally, I would like to be able to just directly import the xml data, using >a schema or some other document that can define this file, or convert it to >element-centric XML, for Access to accept. > >Does anyone know how to do this or done this before or have some pointers I >could use to get me started in the right direction? The creators of this >beast have NO experience with Access or Access databases so are of no help >in this matter. My tax dollars at work. L > >Thanks in advance!!! > >Greg > >Valid XML File for the stated dtd-(watch for wrapping and alignment issues >with this type of file and text): > ><!DOCTYPE REQUEST_GROUP SYSTEM > >"http://iowalandrecords.org/portal/dtd/CLRIS_PRIA_Request.dtd"> ><REQUEST_GROUP> > <REQUESTING_PARTY/> > <RECEIVING_PARTY/> > <SUBMITTING_PARTY/> > <REQUEST> > <KEY _Name="SubmissionID" _Value="4281"/> > <KEY _Name="GroupName" _Value="JFB_Exemption20060831"/> > <KEY _Name="SubmissionNumber" _Value="000000061000004281"/> > ><PRIA_REQUEST_Type="Other"_TypeOtherDescription="ESubmission"> > <PACKAGE> > <PRIA_DOCUMENT _Code="" _NonRecordableIndicator="N" _Type="Deed" >_InstrumentDate="20060831" _CountyOfRecordationName="Scott" >_StateOfRecordationName="IA"> > <GRANTOR _FirstName="First" _MiddleName="mi" _LastName="Last" >_NameSuffix="" _UnparsedName="Last First mi" _Capacity="" >_NonPersonEntityIndicator="N"/> > <GRANTEE _Capacity="" _NonPersonEntityIndicator="N"/> > <PARTIES> > <_RETURN_TO_PARTY> > <NON_PERSON_ENTITY_DETAIL/> > <CONTACT_DETAIL/> > </_RETURN_TO_PARTY> > </PARTIES> > <EXECUTION/> > <RECORDING_ENDORSEMENT> > <_VOLUME_PAGE/> > <_FEES _TotalAmount="31.00"> > <_FEE _Amount="15.00" _Description="StandardFee"/> > <_FEE _Amount="3.00" _Description="DocMgmtFee"/> > <_FEE _Amount="3.00" _Description="ERecordingFee"/> > <_FEE _Amount="10.00" _Description="TransferFee"/> > <_FEE _Amount="0.00" _Description="TransferTax"/> > </_FEES> > <_EXEMPTIONS _Description="Deed fulfilling contract"/> > </RECORDING_ENDORSEMENT> > <EMBEDDED_FILE _Description="" _EncodingType="B64Encode" >_ID="4421" _Name="Cert.pdf" _NumberOfPages="1"> > <DOCUMENT>-BLAH - IMAGE FILE - BLAH BLAH ==</DOCUMENT> > </EMBEDDED_FILE> > </PRIA_DOCUMENT> > </PACKAGE> > </PRIA_REQUEST> > </REQUEST> ></REQUEST_GROUP> > > > > > -- Marty Connelly Victoria, B.C. Canada