存我已经做好了
Set cnn = New ADODB.Connection
cnn.Open constr
Set rs = New ADODB.Recordset
Dim rsstr1 As ADODB.Stream
Set rsstr1 = New ADODB.Stream
Dim rsstr2 As ADODB.Stream
Set rsstr2 = New ADODB.Stream
With rs
.ActiveConnection = cnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "select * from image"
End With
rsstr1.Type = adTypeBinary
rsstr1.Open
rsstr1.LoadFromFile Text10.Text
rsstr2.Type = adTypeBinary
rsstr2.Open
rsstr2.LoadFromFile "d:\yf.doc"
rs.AddNew
rs.Fields("name") = "1001"
rs.Fields("Word1").Value = rsstr1.Read
rs.Fields("Word2").Value = rsstr2.Read
rs.Update
但是我现在不知道怎么取了?
要先启动一个WORD吗?
没有思路!
请大家支着!
最好给出代码!
谢谢
Set cnn = New ADODB.Connection
cnn.Open constr
Set rs = New ADODB.Recordset
Dim rsstr1 As ADODB.Stream
Set rsstr1 = New ADODB.Stream
Dim rsstr2 As ADODB.Stream
Set rsstr2 = New ADODB.Stream
With rs
.ActiveConnection = cnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open "select * from image"
End With
rsstr1.Type = adTypeBinary
rsstr1.Open
rsstr1.LoadFromFile Text10.Text
rsstr2.Type = adTypeBinary
rsstr2.Open
rsstr2.LoadFromFile "d:\yf.doc"
rs.AddNew
rs.Fields("name") = "1001"
rs.Fields("Word1").Value = rsstr1.Read
rs.Fields("Word2").Value = rsstr2.Read
rs.Update
但是我现在不知道怎么取了?
要先启动一个WORD吗?
没有思路!
请大家支着!
最好给出代码!
谢谢
请各位大大不吝赐教!!!
[email protected]
我已经发给你了,但是是在下班的时候发的,不知你收到没有。那是我为你做的一个access的例子,sql的原理是一样的。你把我源程序中的ado连接过程改为sql的连接就可以了(过程我已经写在源码中了)。不只是不是你要的结果,希望给我个回信。
to sala:
我等一下发给你。pdf和doc文件的原理都是一样的。只是oracle的连接我就不知道了。希望你解决后能返回一份给我,让我也学习学习,谢谢了。
[email protected]
[email protected]
[email protected]