insert data from xml file to MS Access using Vb.Net?

SoPathetic

New member
hey guys i have an xml file that contains the structure and records of my database. i want to get the data from the xml file and insert it to ms access. i can already read and get the tables, columns and data type from the xml file (im not using dataset). also i can already create table and add columns to it.. the only problem is that i couldn''t insert the data/records properly and dynamically.

here's what the xmlfile looks:

<customer>
<id>1</id>
<name>joyce</name>
</customer>

i could not put each of the records in a variable because the number of columns and rows/records are dynamic please help me guys..
 
Back
Top