Using a Stored Procedure to Make Bulk Changes to Data in a SQL Server Database : Query « Access « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Access
  3. Query

Using a Stored Procedure to Make Bulk Changes to Data in a SQL Server Database

 
Sub RunUpdateQuery()
    Dim cnn As ADODB.Connection
    Set cnn = New ADODB.Connection
    'Establish the connection and execute a stored procedure
    cnn.Open "Provider=SQLOLEDB.1;" & _
            "Data Source=(local); Initial Catalog=NorthWind;" & _
            "Integrated Security=SSPI"
    cnn.Execute "procIncreaseTotalEstimate"
    cnn.Close

End Sub








Related examples in the same category

1.Creating a Pass-Through Query with ADOX
2.Executing a Pass-Through Query Saved in Access
3.Making Bulk Changes
4.Creating a Query Using Code
5.Create Query by using the Database.CreateQueryDef
6.User Defined Property
7.Get the created query name
8.Delete a query
9.Pass parameter to a query
10.Using CreateParameter to delete a company record
11.Execuate query
12.Update a table with QueryDef