Hi Sanjay,

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

Yes - instead of a new database query, you would build a new web query via
Data | Import External Data. You can specify what table(s) you want to
import and where you want to put them. It should do what you're looking
for.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]