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