Dim rs As New Recordset
Private Sub Form_Load()
rs.Fields.Append "a", adVariant, adFldMayBeNull + adFldIsNullable + adFldUpdatable
rs.Fields.Append "b", adBSTR, , adFldMayBeNull + adFldIsNullable + adFldUpdatable
rs.Fields.Append "c", adBSTR, , adFldMayBeNull + adFldIsNullable + adFldUpdatable
rs.Fields.Append "d", adBSTR, , adFldMayBeNull + adFldIsNullable + adFldUpdatable
End Sub
Private Sub Command1_Click()
Dim i%
rs.Open
For i = 1 To 4
rs.AddNew
rs(0) = "1"
rs(1) = "2"
rs(2) = "3"
rs(3) = "4"
Next
rs.UpdateBatch
Set DataGrid1.DataSource = rs
End Sub