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

Greg Smith gregsmith at starband.net
Fri Nov 3 10:45:36 CST 2006


 (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>






More information about the AccessD mailing list