XML to MySQL

[thelilgreenman]

Ok, here is my problem, ive got a database that is an xml file. its a rather large xml file, 45mb or so, anyways, i am trying to convert it into MySQL. i dont know how to do it.

if i could either get it directly to MySQL, or to a delimited text file or even an access or excel database i would be greatful.

So i guess my question is, is there anyway to convert an XML file to a MySQL DB, a Delimited text file, or a MS excel or Access file?

[limke]

this will be a bit difficult.

Basically, when you want to convert some thing that is in XML form to another type of storing format, you need a XML parser to do so. I do not know whether that mySQL come with the parser or not, but this is the concept of doing.

First, you can develop a XML parser yourself, like using php. Then you parse the XML file by each nodes, obtain in a string, integer, date or any format that u want.

Then with this data, you just do the nomal way that how you store data into mySQL.