Is there any way to try and get the information from an ASP page instead of
directly from the SQL Server.

Thanks
Sanjay

"Juan Pablo Gonzalez" wrote in message
...
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