Posted by chudson007 on 03/14/06 17:30

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.e. can I get my excel macro to link to the Table and if not, what
other solutions are avialable to me.

Regards,
Ciarán

[Back to original message]