K KSKFM Apr 22, 2010 #1 I am importing data from SharePoint list to MSACCESS. I need to strip out html tags from the field values
I am importing data from SharePoint list to MSACCESS. I need to strip out html tags from the field values
A Allen Browne Apr 23, 2010 #2 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().
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().
