XML extraction to t-sql

[OCM]

Greetings,

I'm new to this, and wanted to know how to go about doing the following tasks:

I was given a file in XML format and asked to use T-SQL for the XML extraction and analysis. Submit the results in an Excel spreadsheet,
import the data in the spreadsheets into a SQL Server relational database. Submit the CREATE scripts for all of the objects in the database; briefly explain how I used the data from the spreadsheets to populate the database. The database should be ready to use for accepting new records, as well.

Thank you in advance.

OCM


OCM

 

[harebrain]

Well, that just sounds crazy. Why on earth would you use T-SQL to populate an Excel spreadsheet, then turn right around and use T-SQL to read the spreadsheet to populate a SQL Server table or tables?

What is the purpose of sticking Excel in the middle of this?