Where to start...
 

Hello,

I would like to create an Excel application using VS 2008 that will allow
users to import data from a SQL Server database into a worksheet.

Not sure what the best route to do this would be so I would appreciate a
pointer (e.g. custom task pane, ribbon, vsto, vba, etc.). We get requests
for information all the time and I would like to have the ability for the
users to get it themselves instead of having someone run a query in SQL and
exporting the data to Excel.

Thanks