Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long'工程->引用->Micorosft Word 9.0 Object Library (后面为版本号) Dim cn As New ADODB.Connection, rs As New ADODB.Recordset'保存 Private Sub Command1_Click() Dim stmCon As New Stream
2:用文本字段保存 :要先转成BASE64了
Dim cn As New ADODB.Connection, rs As New ADODB.Recordset'保存
Private Sub Command1_Click()
Dim stmCon As New Stream
stmCon.Type = adTypeBinary
stmCon.Open
stmCon.LoadFromFile "C:\bb.doc"
If rs.State = adStateOpen Then rs.Close
cn.CursorLocation = adUseClient
cn.Execute "DELETE FROM TABLENAME"
rs.Open "SELECT * FROM TABLENAME", cn, adOpenDynamic, adLockOptimistic rs.AddNew
rs!ID = "12"
rs!Name = "bb"
rs.Fields("DOC") = stmCon.Read
rs.Update
stmCon.Close
Set stmCon = Nothing
End Sub'打开
Private Sub Command2_Click()
Dim stmCon As New Stream
If rs.State = adStateOpen Then rs.Close
rs.Open "SELECT * FROM TABLENAME", cn, adOpenForwardOnly, adLockReadOnly
If Not rs.EOF Then
stmCon.Type = adTypeBinary
stmCon.Open
stmCon.Write (rs.Fields("DOC").Value)
stmCon.SaveToFile "C:\aa.doc", adSaveCreateOverWrite
End If ShellExecute Me.hwnd, "open", "C:\aa.doc", vbNullString, vbNullString, 1
End SubPrivate Sub Form_Load()
cn.ConnectionString = "DBQ=" & App.Path & "\TelePhone.mdb;DefaultDir=" & _
App.Path & ";Driver={Microsoft Access Driver (*.mdb)};" & _
"DriverId=25;FIL=MS Access;ImplicitCommitSync=Yes;" & _
"MaxBufferSize=512;MaxScanRows=8;PageTimeout=5;SafeTransactions=0;" & _
"Threads=3;UID=ADMIN;UserCommitSync=Yes;PWD=admind1234;"
cn.Open
'查询字符串可以上这里查
'http://www.connectionstrings.com/
End Sub