Dim rst As New Recordset
With rst
.Fields.Append "类型编号", adBSTR, 10
.Fields.Append "材料类型", adBSTR, 10
.Fields.Append "上期余额", adCurrency, 8
......
.Open
.AddNew
!类型编号=rs!类型编号
!材料类型=rs!材料类型
!上期余额=23.50
......
.Update
End With
set rs=nothing
set dg.DataSource = rst