[AccessD] XML Import into Access 2003 (2nd retry w/o html)

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




More information about the AccessD mailing list