I am trying to display data from access base.
this is what i have so far.

VB Code:
  1. Dim MyConn As ADODB.Connection
  2. Dim MyRecSet As ADODB.Recordset
  3. Dim strName As String
  4. Dim strAddress As String
  5. Dim strPhone As String
  6.  
  7.  
  8. Private Sub Form_Load()
  9.  
  10.  
  11. MyRecSet.CursorLocation = adUseClient
  12. MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "/" & "database.mdb;"
  13.  
  14. MyConn.Open
  15.  
  16. Set MyRecSet = MyConn.Execute("SELECT * FROM Patients")
  17.  
  18. End Sub

i want the stuff to display in flexgrid or datagrid.

how do i go about doing that?