How to Export Rich Text Data into Excel

[EddieN1]

I have a query that includes some Rich Text (html) data in Memo fields. How can I export this data into Excel without all the html tags, <div>, </div>, <bold>, etc.?

[Dal Jeanis]

http://stackoverflow.com/questions/5...in-text-in-vba

Hmmm. Also, MVP Albert Kallal posted here http://www.utteraccess.com/forum/Con...-t1979852.html that there's a plaintext() function as/of Access 2007.

Interestingly, Google provided much better results on that search than Bing did. I'm starting to see a pattern of that.

[EddieN1]

Dal, the Plaintext function works great... Thanks, Eddie