You can have a look at XMLPipeDB. http://sourceforge.net/projects/xmlpipedb/
Iñigo
On 03/09, Sayth Renshaw wrote:
> Hi
>
> Hoping someone can help me work some information or direction to a good
> resource for using XML with Mysql.
>
> Specifically I have a complex XML file, I would like to create a schema in
> MYSQL based on it (I have XSD as well) and be able to upload new xml data
> into the database as it's released to me.
>
> I cannot find a good way to achieve this, currently I am trying to use
> mysql for excel and map via excel into mysql. The data format is complex
> and a bit beyond scope of excel.
>
> Are there good resources that how to work with XML?
>
> Google searches don't show much but confusion and referral to expensive
> software such as XMLspy. If xml was supposed to be a universal format why
> is it so hard to work with.
>
> Sayth.
pgpzWxCo3cswL.pgp
Description: PGP signature
