SQL Server UPDATE Database from Excel Table
 

How do I update SQL Server database through Excel? Can it be done?

If you have the right permissions, then yes.

Here are some examples for getting data to and from Excel and Access. The
procedure is very much the same for SQL server.

It also includes examples of using variables in SQL queries.
http://www.bygsoftware.com/examples/sql.html

Or you can get there from the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

It demonstrates how to use SQL in Excel's VBA to:

* create a database,
* create a table
* insert records
* select records,
* update records,
* delete records,
* delete a table,
* delete a database.

DAO and ADO files available.

You can also download the demonstration file called "excelsql.zip".

The code is open and commented.


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Fawwah" wrote in message
...

How do I update SQL Server database through Excel? Can it be done?


--
Fawwah

What do I have to change to use for SQL Server database instead of Access Database?