Unanswered: RTF (Rich Text Format) field to ASCII Text
I have uploaded a 700,000+ table in SQL Server 2005 and one of the fields is in RTF Format I need to convert it into ASCII Text. If possible, I can add another field for the conversion.
I might access it in Access 2007 if need to use VBA code.
You have to remove all the tags in the RTF file. You could do that with a function that would parse the original file and remove those tags or you could use regular expressions or the Replace function in Access do to the job.