Thread
:
SQL Server UPDATE Database from Excel Table
View Single Post
#
3
Fawwah
Junior Member
Posts: 2
What do I have to change to use for SQL Server database instead of Access Database?
Quote:
Originally Posted by
Andy Wiggins
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
Reply With Quote
Fawwah
View Public Profile
Send a private message to Fawwah
Find all posts by Fawwah