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 - 23 Jan 2008 06:42 GMT
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
> Hi. I have a situation which requires the vba coding of excel to move
> data
[quoted text clipped - 10 lines]
>
> ... john
Tim Zych - 23 Jan 2008 08:38 GMT
How will your solution/Excel know which rows need to be updated vs inserted
vs deleted?

Signature
Tim Zych
SF, CA
> Hi. I have a situation which requires the vba coding of excel to move
> data
[quoted text clipped - 10 lines]
>
> ... john