473,503 Members | 1,691 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

XML string directly to MSAccess table records??

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
0 865

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
1172
by: Joost | last post by:
Hi, I have a msaccess database with more then 50 tables. Each table exist of the history off a specific truck data and excist of a honderd records in each table. (deparute date, arrival date,...
5
5790
by: Paul | last post by:
Hi, I am a self taught VBA programmer, and I'm trying to learn VB2005 Express (The price was right). I like the look of the treeview control, and I'd like to use it as a menu system for my users,...
4
4703
by: gzaxar | last post by:
Hi to all in forum. It is my first post here. I am quite new in MsAccess programming. Here is a problem which i am facing to. I want to keep records of employees CV's. More specifically i want...
1
2951
by: vikramrawal | last post by:
hi, I am using C# with MSAccess XP. I need to insert bulk of records around 10000 in MSAccess. So obviously if I inserts each record individually then it will take lot of time. By using...
3
2660
by: neelesh kumar | last post by:
sir, i have a java applet j2sdk1.4.1_01 .i am using msaccess database . Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"). in my program i want to get records from access table in a new frame...
1
1611
by: jaisi | last post by:
Hi I need to read the data from sql server and convert it into xml ; I configured MsAccess with Sqlserver and i tried exporting a table;I have 5 records in the table; In the xml -only one...
7
3761
by: kashif khan | last post by:
Hi All, I have created a form in MSAccess and linked that form with a table. now in the run mode if i am entering any thing in the textbox and closing the form with out clicking on add record...
1
1271
by: kashif khan | last post by:
Hi All, I have created a form in MSAccess and linked that form with a table. now in the run mode if i am entering any thing in the textbox and closing the form with out clicking on add record...
7
2607
by: cephal0n | last post by:
Hi there! I've been racking my brains out for 4 days and still not getting why is msaccess stubborn about string parsing, first I have a table named tblItems, this table has columns: ProductItem,...
0
7203
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7282
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7339
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6995
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5581
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4678
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1515
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
738
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
389
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.