| ' เพิ่ม reference ชื่อ Microsoft ActiveX Data Objects 2.0 Library
 ' http://www.expert2you.com/article1/2093/index.htm?page_no=1
 ' http://www.thaiio.com/cgi-bin/html/vhtml.pl?name=iotoday&topic=25
 
 Private Sub Form_Load()
 Set cn = New ADODB.Connection
 cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "/Nwind.mdb;"
 cn.Open
 Dim sqlString As String
 Dim rs As ADODB.Recordset
 Set rs = New ADODB.Recordset
 rs.Open "select * from categories", cn
 txt = ""
 rs.Requery
 Do While Not rs.EOF
 txt = txt & rs.Fields("categoryid") & " " & rs.Fields("categoryname") & Chr(13)
 rs.MoveNext
 Loop
 MsgBox txt
 End Sub
 
 
 
 |