Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2008

Tip: Looking for answers? Try searching our database.

moving excel 2003 data to sql server

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JohnE - 23 Jan 2008 06:16 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.