View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
wardellcastles wardellcastles is offline
external usenet poster
 
Posts: 3
Default Updating SQL Server via Excel

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!