For a data-exchange scenario, we need to be able to transform a rather complex XML structure into CSV ... and back again.

We could programme this but I am hoping to find a tool that could cut down some of the 'leg-work'.

The authority which manages the exchange provides ample XSL and XSD files and structure-descriptions which we are hoping to use.

There seem to be a number of tools around (e.g. XML2CSV and others) but some of them seem to be rather limited and I am not sure how they would handle more complex XML structures. Anyway, I am wondering what is recommended? Command-line or graphical? Based on which language?

Our first version will probably be called up from Excel (using VB) but once we have proved the concept we would like to use a language which will also run on a Unix server.

Any tips or links to tutorials would be a great help.

Regards,
Alan