Question : Create a Query and store it into Access database file with VB.NET
Answered by : braxton-bell
Imports System.Data.OleDb
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=D:\myDB.mdb")
Dim cmd As OleDbCommand = New OleDbCommand("CREATE PROC MyQueryName AS SELECT * FROM Table1", con)
con.Open()
cmd.ExecuteNonQuery()
con.Close()
End Sub
End Class
Source : https://social.msdn.microsoft.com/Forums/en-US/e4344a25-93e5-40d4-a97d-c5ee0b573577/running-access-query-in-vbnet?forum=vbide | Last Update : Mon, 04 Jul 22