moving excel 2003 data to sql server

[JohnE]

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

 

[Tim Williams]

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

 

[Tim Zych]

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