Exporting Data from Rich Text Fields?

I have an SQL 2000 database (used by a CRM package), and the field that contains what we call 'History' is a Rich Text Field.

It basically starts like this: {\rtf1\ansi\deff0{\fonttbl{\f0\fnil\fcharset0 Tahoma;} [more follows here]. If I cut and paste this into a text document, rename it to .rtf then it will display the data in Rich Text format.

My problem is that I want to report / migrate some of this data. For reporting, I would like to preserve the rich text formatting within a report, and for data migration purposes I'd ideally like to be able to view it correctly in Excel (2007).

Can anyone give me some advice on how to work with exporting data from Rich Text Fields? I know its quite a general question, but I am new to this and not quite sure where to start researching.

Many Thanks

.

Relevant Pages

  • Re: Dishonest, Reprehensible, Corrupt ...
    ... New York Sun editorial ... That typifies Frank Rich! ... >America involved in the war in Iraq, as the New York Times columnist Frank ... A July 2004 report of the bipartisan Senate Select Committee on ...
    (alt.guitar.amps)
  • Re: Dishonest, Reprehensible, Corrupt ...
    ... That typifies Frank Rich! ... > decision to go to war in Iraq and to blame Mr. Bush and Mr. Cheney for the ... > The Niger Uranium ... A July 2004 report of the bipartisan Senate Select Committee ...
    (alt.guitar.amps)
  • Re: Dishonest, Reprehensible, Corrupt ...
    ... That typifies Frank Rich! ... America involved in the war in Iraq, as the New York Times columnist Frank ... A July 2004 report of the bipartisan Senate Select Committee on ...
    (alt.guitar.amps)
  • Re: Detail Border
    ... none of the graphical aspects work when you export rich text ... Check boxes, lines, rectangles, borders, and logos do not ... This generates the report I have built and they ... and output it to Rich Text Format the lines don't appear. ...
    (microsoft.public.access.reports)
  • Re: Detail Border
    ... button that says Report. ... There would be a box/border around that and the next location would ... and output it to Rich Text Format the lines don't appear. ...
    (microsoft.public.access.reports)
Loading