| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
| RTD server halting Excel while updating | Excel Programming | |||
| Updating a dropdown list from SQL server | Excel Programming | |||
| Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
| problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Linear Mode
