Greetings. I am seeking feedback from the group on the a project handed to
me. What I have is a situation in which there is an xml file updating a table
in SQL Server 2005 4 times per minute. What I am faced with is getting the
info out of sql following the update and placing the information into one or
more excel worksheets, after each update. I have been asked to use a third
party add-in developer inside visual studio 2005. But I am finding that it
might be more work then it is worth and some difficulty in getting my mind
around it. My thought is Excel could handle the task directly without any
intervention from a third party. Excel is even capable of creating an
add-in. The extraction of the data from sql can be done thru stored
procedures, which may have or may have not parameters.

So, am I way off base here regarding excel, sql, and third party add-in
developer, and excel can handle it on its own?

Let me know your thoughts on this.

Thanks.

.... John