How to convert xml to sqlite?

Question

I have an xml file that has a lot of info that I would like it to be in sqlite tables.

I am wondering if there's any tool, app to transform xml to sqlite.

By the way I am on OS X and I need the info for an iPhone app, so I can also take scripts or some source code to make the trasmformation.

Answer 1

Use XSLT to transform the XML into insert statements.