Guest User

Untitled

a guest
Apr 26th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. Dim connectionString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data
  2. Source=C:ProjectenTest.xlsx;Extended Properties = ""Excel 12.0
  3. Xml;HDR=YES"""
  4.  
  5. Dim connection As New OleDbConnection(connectionString)
  6. Dim updateStatement As String = "UPDATE [Rondelijst$] SET [interval] = 'Maandelijks' WHERE [KKS] = 'GKC20AT001'"
  7. Dim command As New OleDbCommand(updateStatement, connection)
  8.  
  9. connection.Open()
  10. command.ExecuteNonQuery()
  11. connection.Close()
Add Comment
Please, Sign In to add comment