How will your solution/Excel know which rows need to be updated vs inserted
vs deleted?

--
Tim Zych
SF, CA

"JohnE" wrote in message
...
Hi. I have a situation which requires the vba coding of excel to move
data
from an excel 2003 worksheet to sql server 2005. I am somewhat familiar
with
vba but not in moving it like this. Also, as the data updates on the
worksheet, the vba needs to fire at set times (ex: every 5 secs) to update
the sql server 2005.

So I seek the wisdom of the group to see if anyone has done this and how,
know of some documentation about it, or know of samples to look at?

Thanks in advance for the assistance.

... john