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

You could try exporting the field as is into a text file (using dts or
xp_cmdshell) and then use a dts activeX task to rename the file to .rtf

--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts


"Zaheer Jassat" wrote in message

>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