use VB to query database
Posted on 2006-07-17
I have a table in MS Access (or MS SQL server). the table has two fields like below.
And so on…
how can I use sql query in VB to query some result (ex. mean, max, avg in field 1) and then assign to a variable. something like below.
Dim max_num as double
max_num = select max(field1) from table1
I am familiar with SQL query, but I don't know how to connect to Access and then get query result from Access (or MS SQL server).