exporting and importing from SQL Server to Excel

Hi

I know that using the data transformation services I can import and export data to a spreadsheet from SQL Server. However, Id like a user of my web site (written in asp) to be able to do this as required. They would either request that a tables contents are exported into a spreadsheet or that a spreadsheet that they specify is imported into a table. Is there any way to run a predefined data transformation service from a stored prodcedure? Or are there any stored procedures that can import/export data? Can anyone think of another way of accomplishing this?

Thanks for any input!