how to remove html tags from a field in MSACCESS.

K

KSKFM

I am importing data from SharePoint list to MSACCESS. I need to strip out
html tags from the field values
 
A

Allen Browne

What version?

If you are using Access 2007 or 2010, you could use the PlainText()
function, or store the data in a RichText memo field.

Otherwise you may need to use Instr() to locate the "<" and the following
">", Len() and Mid().
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top