Import WordPad RTF file into an RTF Memo field in Access 2007

[genojoe]

I would like to import and export RTF documents into a table memo field that
supports RTF using code. For exporting text, I use the following

sFile = "c:\temp\EmailsSent.txt"
sText = Now & " is the date sent."
Dim a As Object
Dim fs As Object
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.OpenTextFile(sFile, 8, False)
a.WriteLine (sText)
a.Close

Is there similar code that I can use to transfer the contents of an RTF memo
field in a table to and from an RTF file?

 

[Rick Brandt]

I would like to import and export RTF documents into a table memo field
that supports RTF using code. For exporting text, I use the following

sFile = "c:\temp\EmailsSent.txt"
sText = Now & " is the date sent."
Dim a As Object
Dim fs As Object
Set fs = CreateObject("Scripting.FileSystemObject") Set a =
fs.OpenTextFile(sFile, 8, False) a.WriteLine (sText)
a.Close

Is there similar code that I can use to transfer the contents of an RTF
memo field in a table to and from an RTF file?

If you are talking about the new "rich text" feature in Access 2007 I
think you will have problems because it is actually HTML, not "real" rich
text.