1,216
社区成员
发帖
与我相关
我的任务
分享
Dim arrF As Variant
Dim arrD As Variant '只能是1维数组,二维数组取1维
arrF = Array("Date", "Type", "Value")
arrD = Array("2011-03-31", "a", 1)
Set rs = New ADODB.Recordset
' 创建断开连接的记录集append,既然数据库有这些就不用了
' rs.Fields.Append "Date", adBigInt
' rs.Fields.Append "Type", adVariant
' rs.Fields.Append "Value", adVariant
rs.Open "select Date,Type,Value from xx表 "
rs.AddNew arrF, arrD
' Recordset.Update Fields, Values '---同addnew