Search google on "ADO": using this you can easily insert records into a sql
server DB.
Beyond that it depends how complex your "updates" are (just inserting ,or
updating existing records?)
You can use "ontime" to schedule the updates.

Tim


"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