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.
July 29, 2008 8:22 PM
July 30, 2008 2:48 PM