日期:2012-06-01 浏览次数:20511 次
'构造Recordset 的字段名和类型
rsConstruct.Fields.Append "Field1", adInteger
rsConstruct.Fields.Append "Field2", adVarWChar, 128
rsConstruct.Fields.Append "Field3", adVarWChar, 128
rsConstruct.Fields.Append "Field4", adVarWChar, 128
rsConstruct.Open
'增加记录至Reocrdset
If colTemp.count > 0 Then
For i = 1 To colTemp.count
rsConstruct.AddNew
rsConstruct.Fields("Field1") = 0
rsConstruct.Fields("Field2") = colTemp.Item(i).Subject
rsConstruct.Fields("Field3") = colTemp.Item(i).Description
rsConstruct.Fields("Field4") = colTemp.Item(i).RefURL
rsConstruct.Update
Next