Retrieving data from database (MS Sql Server) to Excel
 

i have a database using MS Sql Server
i also have an Excel form which retrieves certain data from the database
the hard thing here is the data needs to be updated each time the Excel form
is opened/viewed.
i will be uploading my project to my server , hence user just need to enter
the url something like - http://servername/projectname/sheet1.xls