XML string directly to MSAccess table records??

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Don

    #1

    XML string directly to MSAccess table records??

    Is there a way to append the records in an XML string variable
    (example below) directly to an MSAccess table?

    Thank you,

    Don


    EXAMPLE of strOFX_XML:

    -<OFX>
    - <STMTTRN>
    <TRNTYPE>DEBI T</TRNTYPE>
    <DTPOSTED>20050 912120000</DTPOSTED>
    <TRNAMT>-1.61</TRNAMT>
    <FITID>20050912 13</FITID>
    <NAME>POS PURCHASE - SAFEWAY STORE SAF</NAME>
    </STMTTRN>
    - <STMTTRN>
    <TRNTYPE>DEBI T</TRNTYPE>
    <DTPOSTED>20050 912120000</DTPOSTED>
    <TRNAMT>-3.00</TRNAMT>
    <FITID>20050912 12</FITID>
    <NAME>POS PURCHASE - FRED MEYER </NAME>
    </STMTTRN>
    - <STMTTRN>
    <TRNTYPE>DEBI T</TRNTYPE>
    <DTPOSTED>20050 912120000</DTPOSTED>
    <TRNAMT>-3.26</TRNAMT>
    <FITID>20050912 11</FITID>
    <NAME>POS PURCHASE - SOU STAPLES </NAME>
    </STMTTRN>
    </OFX>
Working...