Imports System.Data.OleDb
Dim s_filename as String = "c:\myaccessdatabase.mdb"
Dim mydatareader As OleDbDataReader
Dim myconnection As OleDbConnection
Dim mycommand As OleDbCommand
myconnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & s_filename & ";")
myconnection.Open()
mycommand = New OleDbCommand("SELECT * FROM .........", myconnection)
mydatareader = mycommand.ExecuteReader
While mydatareader.Read()
' handle data
End While
mydatareader.Close()
myconnection.Close()
Getting data from an access database
This code sample demonstrated how to access data in an msaccess database from vb.net code.