保存文件是rtf Dim d As New ADODB.Recordset Dim mstream As New ADODB.Stream d.Open "select * from YouTable",Conn, adOpenKeyset, adLockOptimistic With mstream
.Type = adTypeBinary .Open .LoadFromFile YouFileName d.Fields("FMem").Value = mstream.Read d.Update end with
读的过程With mstream .Type = adTypeBinary .Open If Not IsNull(d.Fields("FMem")) Then .Write d.Fields("FMem").Value .SaveToFile YouFileName, adSaveCreateOverWrite endif end with
a TBlobField(Query1.FieldByName( 'RichEdit ')).Assign(RichEdit1.Lines);
=================
.Lines不行的话改为.Lines.Text
b TBlobField(Query1.FieldByName( 'RichEdit ')).LoadFromFile(filename); show:
RichEdit1.Lines.Assign(Query1.FieldByName( 'RichEdit '));
http://office.microsoft.com/zh-cn/access-help/HA010014097.aspx
Dim d As New ADODB.Recordset
Dim mstream As New ADODB.Stream
d.Open "select * from YouTable",Conn, adOpenKeyset, adLockOptimistic
With mstream
.Type = adTypeBinary
.Open
.LoadFromFile YouFileName
d.Fields("FMem").Value = mstream.Read
d.Update
end with
.Type = adTypeBinary
.Open
If Not IsNull(d.Fields("FMem")) Then
.Write d.Fields("FMem").Value
.SaveToFile YouFileName, adSaveCreateOverWrite
endif
end with