SELECT * FROM table1 WHERE column1 BETWEEN 10 AND 50
Dim constr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\mydata.accdb" Dim mycon As New OleDbConnection(constr) Dim myadapter As New OleDbDataAdapter("select * from mytable where num between 1 and 20", mycon) Dim mytable As New DataTable() Dim myset As New DataSet() mycon.Open() myadapter.Fill(myset, "mytable") mycon.Close() mytable = myset.Tables(0) DataGridView1.DataSource = mytable