DaniWeb IT Discussion Community - how to convert xml format into sql database format?

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- XML, XSLT and XPATH (http://www.daniweb.com/forums/forum134.html)

- - how to convert xml format into sql database format? (http://www.daniweb.com/forums/thread149665.html)

ms.izyan

Oct 7th, 2008 4:53 am

how to convert xml format into sql database format?

im new in xml. i already know how to convert sql into xml, but now i wanna convert a file in xml format into table format (sql database). The xml file is shown below. pls help me.. :(

<menu>

<menuitem>
<food>french tost</food>
<price>12.45</price>
</menuitem>

<menuitem>
<food>bread</food>
<price>3.00</price>
</menuitem>

</menu>

All times are GMT -4. The time now is 5:43 pm.