rtf text in SQl Server

5 pts.
Tags:
Microsoft Access
Microsoft Word
Rich text
SQL Server 2005
We need to migrate a column of rtf-encoded text in SQL Server 2005 to a plain text field in a different table. Using Access, I can save the encoded text in a .rtf file, then open the file in Word and save it as a .txt, then read the .txt back into Access - Word strips out the rtf tags and returns a plain text file with embedded CR/LF. However, this is a time-consuming process (1000 records took around 20 minutes) and I have 160K records to process. Does anyone know how to do this more efficiently (e.g, without using Access and/or Word)? I thought about writing a .net app; however, I don't have the Visual Studio tools for Office, so I'm not sure if I can create and control a Word object from .net. Thanks, EricF

Answer Wiki

Thanks. We'll let you know when a new response is added.

These might be a place to start as far as controlling the Word application with .net:

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following