I am able to connect to a db and send a SQL successfully, but I need the results to populate a grid or table. How can I do that? Below is the code that connect to the db and returns the records one by one to a msgbox.
Thanks in advance.
<TITLE>Working With VBScript: Exercise 2</TITLE>
<!-- Add this to instruct non-IE browsers to skip over VBScript modules.
set conn = CreateObject("ADODB.Connection")
' Connect to the database
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=R:\TMP\testDB.mdb;"
msgbox "db opened"
StrSQL = "SELECT * FROM claimCounts WHERE Submitted >244000"
Set rs = conn.Execute(StrSQL)
Do While not rs.EOF
msgbox "The information is " & RS(0)