I have to export some data to load to another system


The team on the other system have provided templates for what they want as XML but are happy to get delimited files back.

I thought I could create some temporary tables in SQL to match the XML and then load the data into those tables and then export it as a delimited file.

My question then is .. Is there an easy way to create a sql table definition from an XML file.

Thanks

Nick