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