RSstream.Type = adTypeBinary
RSstream.Open
RSstream.Write rs.Fields("image").Value
RSstream.SaveToFile "c:\temp1.jpg", adSaveCreateOverWrite
RSstream.Close
RSstream.Open
RSstream.Write rs.Fields("image").Value
RSstream.SaveToFile "c:\temp1.jpg", adSaveCreateOverWrite
RSstream.Close
Dim cnn As New ADODB.Connection
Dim RSstream As New ADODB.Stream
Dim rs As New ADODB.Recordset
cnn.Open "driver={sql server};server=(local);database=pubs;uid=sa;pwd=" '我这里是用大型数据,你可以改成小型也没关系但字段要注意一下。
With rs
.ActiveConnection = cnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Open "select * from temp11" '这个表中要有image字段类型是image或者是text类型的
End With
If rs.RecordCount <> 0 Then rs.MoveFirst
RSstream.Type = adTypeBinary
RSstream.Open
RSstream.Write rs.Fields("image").Value
RSstream.SaveToFile "c:\aa.jpg", adSaveCreateOverWrite '保存为文件
RSstream.Close