Yes, that all can be done.

To start, try using Data | Get External Data, New Database Query...

you can record a macro while you do that, which will give you the basic code
that you need to connect to the SQL server.

Regards,

Juan Pablo González

"Sanjay Singh" wrote in message
...
I am building a reporting solution with Excel 2000. I would like the
spreadsheet to be able to download data from SQL Server on our website.

The data will go into a specific range on my spreadsheet on which further
calculations can then take place.

If possible I want this to be controlled from Excel i.e. User will press a
button on a customized Excel toolbar which will then run some code to
carry
out the above.

Can this be done.

Thanks in advance
Sanjay