This is a very general quastion.....

I regularily take data extracts from a SQL server database drop them in
excel and run a macro on the data.

The macro does nothing more complicated than loops, addition,
subtraction and remeber the changing value of a declared variable.
It works perfectly, but is constrained by the number of rows in excel.

I want to investigate the possibilty doing the calculations in the SQL
tables. (All the data is contained within one table).

What is the best way to approach this problem.
i=2Ee. can I get my excel macro to link to the Table and if not, what
other solutions are avialable to me.

Regards,
Ciar=E1n

T-SQL is essentially a standard 3rd generation language (with some
limitations, obviously), so if you can do it in Excel, you can probably
do it in a T-SQL procedure, all in one place without having to transfer
and re-load the data.

JG

Thank you