rtf text in SQl Server
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
Software/Hardware used:
Software/Hardware used:
ASKED:
July 29, 2008 8:22 PM
UPDATED:
July 30, 2008 2:48 PM
Answer Wiki:
These might be a place to start as far as controlling the Word application with .net:
http://www.codeproject.com/kb/miscctrl/winwordcontrol.aspx
http://www.codeproject.com/KB/files/rtftotxtconvertor.aspx?fid=207487&df=90&mpp=25&noise=3&sort=Position&view=Quick&fr=26
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
