By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,260 Members | 1,338 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,260 IT Pros & Developers. It's quick & easy.

XML string directly to MSAccess table records??

P: n/a
Don
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>DEBIT</TRNTYPE>
<DTPOSTED>20050912120000</DTPOSTED>
<TRNAMT>-1.61</TRNAMT>
<FITID>2005091213</FITID>
<NAME>POS PURCHASE - SAFEWAY STORE SAF</NAME>
</STMTTRN>
- <STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20050912120000</DTPOSTED>
<TRNAMT>-3.00</TRNAMT>
<FITID>2005091212</FITID>
<NAME>POS PURCHASE - FRED MEYER </NAME>
</STMTTRN>
- <STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20050912120000</DTPOSTED>
<TRNAMT>-3.26</TRNAMT>
<FITID>2005091211</FITID>
<NAME>POS PURCHASE - SOU STAPLES </NAME>
</STMTTRN>
</OFX>
Feb 12 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.