I see a lot of posts on this subject; none of which seem to address my
issue.
I am running MS Office Excel 2003 and want to update a table located in
a database in SQL Server 2000.
Using VBA for Excel, what options do I have to connect to the database
and then execute an "UPDATE" or "INSERT" SQL statement?
Can someone provide some code snippets or web page references on the
syntax?
Thanks!
Bookmarks