Thanks for the SQLDiag hint.  Will definetly do.  As for the resources, the resource looks like this:

KEY: 13:101575400:1 (e901b18a7966)

So 101575400 is a specific table in my database.  My block...

No problem at all.  I will create a blank workbook having N worksheets with headers.  I will name the worksheets sequentially: Sheet1, Sheet2, ... , SheetN (This can be automated,...

It looks like a perfect solution for me.  Thanks heaps.

I was asking a similar question: why Excel... why not Analysis Services?  It looks like this is the form users are used to use and they want nothing else...

Hi,

This is my query:

Select ContractId ,

 Balance,

 Charge_Receivables ,

 Residual ,

 Interest ,

 Asset ,

 Income,

 Charges

From ContractAccount

Where Accountid in (select disticnt Accountid from ContractAccount (nolock))

Accountid defines categories.  I want all data, related...

The same as above, I can't allow every user to do this and the report should run at a particular time overnight, as it is heavy.  I prefer to sleep...

The dataset is too large to allow everyone query the database to populate their own file.  So there has to be just one file to be copied from by all...

This could be a solution, but I am not good in Active X area.  Do you know about any examples of similar code on the web?

I will think about this way, but I am afraid this will be very slow as the record set is very large.  Worth trying anyway. 

I was also considering building a script...

Thanks, but I already have a solution which breaks data into separate worksheets, which is a great CPU killer, so I want to find a way to dump everything into one...

"That's a nice trick, wish I had known it a few months earlier! Andy http://www.sqlservercentral.com/columnists/awarren/

Andy

http://www.endtoendtraining.com/"

"I ran into this a couple years ago..."

Nice solution, but it was discussed on this forum three years ago and you may remember this topic... Followers