this shows a previous post where I describe running a stored proc.

http://tinyurl.com/b4ewn

4 million rows is not a lot. One way or another you should have a primary
key set on the table that will give you a start towards indexing it. You
could also try creating a trace file using Profiler testing your typical
activities then use the index tuning wizard in enterprise manager with the
trace.

Robin Hammond
www.enhanceddatasystems.com

"joaovtt" wrote in
message ...

I'm sorry, but how can I call a stored procedure from a excel macro?


My table has up to 4 million records... At the moment, I'm not using
any indexes because it's a table for staging in a ETL process. If I use
indexes any time I truncate and insert in this table, these indexes will
be update?


--
joaovtt
------------------------------------------------------------------------
joaovtt's Profile:
http://www.excelforum.com/member.php...o&userid=24286
View this thread: http://www.excelforum.com/showthread...hreadid=381734