Имена столбцов - VB - Ответ 4579596

Dim statement As String
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim c As Integer
Dim r As Long
 
    Set conn = New ADODB.Connection
    conn.ConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)};driveId = 277 ; Dbq=" & Trim(frmMyForm.TextBox2.Text) & ";"
    conn.Open
 
    statement = "SELECT * FROM TEL"
    
    Set rs = conn.Execute(statement, , adCmdText)
 
    MSFlexGrid1.Rows = 2
    MSFlexGrid1.FixedRows = 1
    MSFlexGrid1.FixedCols = 1
 
    MSFlexGrid1.Rows = 1
    MSFlexGrid1.Cols = rs.Fields.Count + 1
 
    For c = 0 To rs.Fields.Count - 1
        MSFlexGrid1.TextMatrix(0, c) = rs.Fields(c).Name
    Next c
 
    r = 1
    Do While Not rs.EOF
        MSFlexGrid1.Rows = MSFlexGrid1.Rows + 1
        For c = 0 To rs.Fields.Count - 1
            MSFlexGrid1.TextMatrix(r, c + 1) = _
                rs.Fields(c).Value
        Next c
 
        rs.MoveNext
        r = r + 1
    Loop
 
    rs.Close
    conn.Close
 
    Call UPDGrid

    For c = 0 To rs.Fields.Count - 1
        MSFlexGrid1.TextMatrix(0, c) = rs.Fields(c).Name
    Next c