Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2008

    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.

  2. #2
    Join Date
    Mar 2009
    Provided Answers: 14
    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.

    For explanations about RTF format see: Rich Text Format (RTF) Version 1.5 Specification

    Have a nice day!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts