View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Braindeadbeachbum Braindeadbeachbum is offline
external usenet poster
 
Posts: 10
Default Reading Wordpad - Rich Text Format

Hey Guys

I need to read a Worpad format in Excel.

I depend on a wordpad app to input text to a SQL database. I then read the
text field from the DB via ADO into Excel using nvarchar for the text field
as this is RTF. The text I get back looks like the following:

================================================== ===================
{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil MS Sans
Serif;}{\f1\fnil\fcharset0 MS Sans Serif;}{\f2\fswiss\fprq2\fcharset0 Arial;}}

{\colortbl ;\red0\green0\blue0;}

\viewkind4\uc1\pard\cf1\lang1033\f0\fs20 SPOKE RIETTE AND INFORMED HER THAT
CALLS WERE LOGGED INCORRECTLY I GAVE HER A NUMBER TO HELP HER OUT


\par

\par THE PRINTER IS FAULTY

\par \f1 called and confirmed with the user that the call can be closed.

\par \f2\fs18

\par }
================================================== ===================

All I want is the actual text:

================================================== ===================
SPOKE RIETTE AND INFORMED HER THAT CALLS WERE LOGGED INCORRECTLY I GAVE HER
A NUMBER TO HELP HER OUT

THE PRINTER IS FAULTY
called and confirmed with the user that the call can be closed.

================================================== ===================

I know its a long shot but is there any way I can format the field within
Excel to read Rich Text Format?

Please help!