I frequently need to import data that I get in the form of Excel sheets into multiple related tables of a database. It takes a long time to write the stored procedures that can do this for each different occasion.
I keep hearing about updategrams and XML Bulk Load - although I know very little of them they seem to be able to insert related records (like OrderHeader and OrderDetails) into multiple tables with a single run.
Is it possible (worth) creating an XML document from the Excel sheet and import that instead of writing a stored procedure that will do the import? If yes could you give me an example.