Reading Multiple Rows of Data

The table interface is an efficient way of reading large amounts of data with little overhead. It should be used extensively in the performance-sensitive areas of the application.

The following sample code shows how to use the table interface to read large amounts of data:

Private Sub GetData()
    Dim objAppts As Object
    Dim arrData As Variant
    Dim i As Integer
    
    Set objAppts = objSchedule.Appointments
    arrData = Array(9, 2)
    arrData = objAppts.GetRows(10, "Start", "End", "Text")
    
    For i = 0 To 9
        Debug.Print arrData(i, 0), arrData(i, 1), arrData(i, 2)
    Next
End Sub