Convert RTF to TXT to enable linking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have rtf files that I need to import into Access. Since Access can't link
to rtf files, I believe I will need to convert them to text first.

Does anyone know how to do this with vba code?

While there are utilities available, what I have seen wouldn't be feasible
since I have thousands of files.

I appreciate any assistance.

Thanks.
 
First of all you can link to RTF files using MS Word as the OLE Automation
server for this file type.

If you simply want to get at the text, place a Rich Text ActiveX control on
your form and bind it to a Memo field. Copy the exact contents of your RTF
files into your Memo field. Now you can use the properties of the RTF
control to access the plain Text for each row of the table.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Thanks for the suggestion. Can you point me in the right direction for the
first option?

I think that is what would work best but I am unsure of the code.
 
Back
Top