RE:comoseprograma un msflexgrid
Private Function encheGrid(datos As String, sql As String)
Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim columa As Integer
Dim linea As Integer
Dim l_columna() As Single
Dim l_campo As Single
' abre una conexion
Set Cn = New ADODB.Connection
Cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & datos & ";" & "Persist Security Info=False"
Cn.Open
' Carga los Registros
Set rs = Cn.Execute(sql, , adCmdText)
' define lineas fijas igual a uno y no usa columnas fijas
MSFlexGrid1.Rows = 2
MSFlexGrid1.FixedRows = 1
MSFlexGrid1.FixedCols = 0
' Define el numero de lineas y columnas y crea una matrix con un total de registros a exibir
MSFlexGrid1.Rows = 1
MSFlexGrid1.Cols = rs.Fields.Count
********** parte1****