'** 引用 Microsoft ActiveX Data Objects 2.5 Library 及以上版本 Dim iConcstr As String Dim iConc As ADODB.Connection'保存文件到数据库中 Sub s_SaveFile() Dim iStm As ADODB.Stream Dim iRe As ADODB.Recordset Dim iConcstr As String
'读取文件到内容 Set iStm = New ADODB.Stream With iStm .Type = adTypeBinary '二进制模式 .Open .LoadFromFile App.Path + "\com.doc" End With
'打开保存文件的表 Set iRe = New ADODB.Recordset With iRe .Open "select * from img", iConc, 1, 3 .AddNew '新增一条记录 .Fields("photo") = iStm.Read .Update End With
'完成后关闭对象 iRe.Close iStm.Close End SubSub s_ReadFile() Dim iStm As ADODB.Stream Dim iRe As ADODB.Recordset '打开表 Set iRe = New ADODB.Recordset iRe.Open "select * from img", iConc, adOpenKeyset, adLockReadOnly iRe.Filter = "id=6"
'保存到文件 Set iStm = New ADODB.Stream With iStm .Mode = adModeReadWrite .Type = adTypeBinary .Open .Write iRe("photo") .SaveToFile App.Path & "\cc.doc" End With 添加一个ole控件 OLE1.SourceDoc = App.Path & "\cc.doc" OLE1.Action = 1 'use the old action method OLE1.SizeMode = vbOLESizeAuttoSize '调节对象大小使其正好充满OLE容器控件
'关闭对象 iRe.Close iStm.Close End SubPrivate Sub Command1_Click() Call s_ReadFile End SubPrivate Sub Command2_Click() Call s_SaveFile End SubPrivate Sub Form_Load() '数据库连接字符串 iConcstr = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False" & _ ";Data Source=F:\csdn_vb\database\保存图片\access\img.mdb" Set iConc = New ADODB.Connection iConc.Open iConcstr End Sub
see:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;258038
http://office.9zp.com/dispbbs.asp?boardID=15&ID=2162
Dim iConcstr As String
Dim iConc As ADODB.Connection'保存文件到数据库中
Sub s_SaveFile()
Dim iStm As ADODB.Stream
Dim iRe As ADODB.Recordset
Dim iConcstr As String
'读取文件到内容
Set iStm = New ADODB.Stream
With iStm
.Type = adTypeBinary '二进制模式
.Open
.LoadFromFile App.Path + "\com.doc"
End With
'打开保存文件的表
Set iRe = New ADODB.Recordset
With iRe
.Open "select * from img", iConc, 1, 3
.AddNew '新增一条记录
.Fields("photo") = iStm.Read
.Update
End With
'完成后关闭对象
iRe.Close
iStm.Close
End SubSub s_ReadFile()
Dim iStm As ADODB.Stream
Dim iRe As ADODB.Recordset
'打开表
Set iRe = New ADODB.Recordset
iRe.Open "select * from img", iConc, adOpenKeyset, adLockReadOnly
iRe.Filter = "id=6"
'保存到文件
Set iStm = New ADODB.Stream
With iStm
.Mode = adModeReadWrite
.Type = adTypeBinary
.Open
.Write iRe("photo")
.SaveToFile App.Path & "\cc.doc"
End With
添加一个ole控件
OLE1.SourceDoc = App.Path & "\cc.doc" OLE1.Action = 1 'use the old action method
OLE1.SizeMode = vbOLESizeAuttoSize '调节对象大小使其正好充满OLE容器控件
'关闭对象
iRe.Close
iStm.Close
End SubPrivate Sub Command1_Click()
Call s_ReadFile
End SubPrivate Sub Command2_Click()
Call s_SaveFile
End SubPrivate Sub Form_Load()
'数据库连接字符串
iConcstr = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False" & _
";Data Source=F:\csdn_vb\database\保存图片\access\img.mdb" Set iConc = New ADODB.Connection
iConc.Open iConcstr
End Sub