You say that you don't want to use DTS or SSIS.

Have you consider to use Excel and VBA instead?

If you have Excel installed at the "production machine" then think about it.

The nice thing is that you have much more control of Excel formulas and formats

and can combain the figures with filtering and charts. Your result is more "reportlike"

including analysing/filtering/pivoting options if you like.

I do a lot of jobs creating and distributing Excel files and started with DTS and

stored procedures but now I do it all in Excel and VBA.

If you already are familiar with Excel and VBA the step to add ADO with Database functions is not scaring.