Dim dbs As DAO.Database
Dim strSql As String
Dim strTblName As String
Dim strFieldName As String
Dim rs As DAO.Recordset
Dim rs2 As DAO.Recordset
'Set dbs = CurrentDb
'strTblName = "tblStudents"
strTblName = "ImageStore"
strSql = "select * from " & strTblName
Set rs = CurrentDb.OpenRecordset(strSql)
'rs.Edit
rs.AddNew
rs(0) = 10
rs(1) = 1
rs(2) = 5
rs(3) = "c:\testpath\img1.gif"
' Add a new attachment.
Set rs2 = rs.Fields("image_pic").Value
rs2.AddNew
rs2.Fields("FileData").LoadFromFile "c:\testpath\img1.gif" '"c:\ggg\altBackGrd.gif"
rs2.Update
rs2.Close
rs.Update
rs.Close
Set rs2 = Nothing
Set rs = Nothing
End Sub作者: zpy2 时间: 2015-9-5 11:25
http://www.office-cn.net/forum.php?mod=viewthread&tid=120888&fromguid=hot&extra=&mobile=1&simpletype=no作者: 522650696 时间: 2016-4-14 17:11